Repeat a Sub report in SSRS - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Repeat a Sub report in SSRS

Author

Topic

kneekill
Yak Posting Veteran

76 Posts

Posted - 2010-12-07 : 03:35:22

Hi

I have report (ReportA) which display some data based on a non queried parameter ID.

Example: When ID = 1

ID---Name
1----XYZ

Now i want display a report (report B) for multiple "IDs". report B will take a non queried parameter IDs.

Now I want to use Report A as a sub report in Report B and repeat the report A for each ID split by comma. (Note I have to use report A, my real time scenario is pretty huge with report A having multiple datasets etc.)

Example: When ID = 1,2,3

ID---Name
1----XYZ

ID---Name
2----ABC

ID---Name
3----QWE

How can i do implement this functionality. Please help and point me to the right direction.

If possible please provide me any on line links/resources

Thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources