July 20, 2010 at 12:05 pm
I need to clean up some SSRS reports. Currently the report data sources are views, or joined views. This is only for the reports that pull from the relational database.
I've been advised to create a stored procedure that pulls data for each report. Is this a best practice?
How do others set this up?
July 20, 2010 at 4:17 pm
There is not really a best practice I am aware of in regards to using views/select statements vs. stored procedures to return the data. There are tradeoffs to both approaches. It really comes down to a question of maintenance and security. If the select query is in the report, modifying the report to add new fields becomes fairly easy as you just need to modify the query. With the stored procedure, the stored procedure would need to modified and then the query rerun in the report builder to bring in the new fields. If it is a public facing report, I would highly recommend the stored procedure route as the actual query can be viewed in the report rdl. Hopefully that helps some.
July 20, 2010 at 5:23 pm
Thank you. This is very helpful.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply