Reusable datasets
I use a common set of parameters in several Reporting Services reports. The parameters are populated with queries defining datasets. Is there any way to maintain these queries centrally and reuse them in multiple reports without having to cut and paste SQL into each report definition? Leo
October 20th, 2010 9:20pm

If you're using SQL Server 2008 R2, then yes - shared datasets are a new feature in that version. Otherwise, no - you just have to repeat the query in each report that needs them.-cd Mark the best replies as answers!
Free Windows Admin Tool Kit Click here and download it now
October 20th, 2010 11:05pm

I use a common set of parameters in several Reporting Services reports. The parameters are populated with queries defining datasets. Is there any way to maintain these queries centrally and reuse them in multiple reports without having to cut and paste SQL into each report definition? Leo Other option is, you can convert the query into SP and call the Stored Procedure.
October 20th, 2010 11:42pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics