October 25, 2011 at 5:49 pm
Hi Im a newbie with SSRS deveopment but i at work i need to develop some reports for which i reviwed a couple of reports made by some consultant which had multiple data sets entered from various custom t-sql queries or storeprocedures .
My questions is how do i decide when to use multiple datasets and where to use them ?
Suggestions and answered greatly appreciated .
Thanks
October 27, 2011 at 7:19 am
abcuser (10/25/2011)
My questions is how do i decide when to use multiple datasets and where to use them ?
How about taking into consideration the Business Requirements?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.October 27, 2011 at 7:42 am
As the previous poster mentioned, you need multiple datasets based on requirements.
I think your report has multi parameters or more than one data region.
usually you need multiple datasets if you need to show for instance multi-select values for a parameter in your report. also if there are multiple dataregions in your report.
I would suggest click on each individual data-region (table/matrix) and see where it gets its value from in the properties of that data region.
Also check out the report parameters, you will see that if your report has multi select parameters and where they get there drop-down values from.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply