July 24, 2012 at 2:42 pm
Via RS can I have a user to enter 4 parameters(Fname, Lname, City, State) and that data will be store in a table on the back-end?
July 24, 2012 at 5:44 pm
kd11 (7/24/2012)
Via RS can I have a user to enter 4 parameters(Fname, Lname, City, State) and that data will be store in a table on the back-end?
Since noone else came by with a solution, and so you're not just hanging, as far as I am aware the answer here is "Not by default".
SSRS is a read only construction. HOWEVER, you can cause this to happen via procedures that SSRS calls for the data for the report. However, they'll be constantly overwriting each other in a multi-user environment, as you can't easily pass the user information back unless you send it as a parameter as well, and when calling the defaults you won't know which user is involved, so I recommend avoiding that.
In the end, though, it comes back to why are you doing this? What business requirement are you trying to solve with having SSRS write to the DB?
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
July 25, 2012 at 9:27 am
Generally I recommend using stored procedures as a rule for reports.
Create your SP to pull your data and save it to your table, then at the end of the SP select the table data you just wrote as the output for your report. The downside is an unnecessary round trip to the database from the report's point of view, but it sounds like what you need.
You could also do this with an inline query if needed.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply