CODEWITHSUNDEEP
reporting-servicesssrs-2008
Amarundo
Amarundo

Reputation: 2397

How to do a Sub Report in SQL Server Reporting Services

I developed a report in Reporting Services 2008 R2 that takes 3 parameters:

And produces some data from 4 different Data Sets.

What I want to do next is allow multiple UserId choices and produce the report with one page per User. I thought I would be able to do that by using a List, and throwing all those other tables inside the list, but it doesn't let me, as it says the list has to draw data from only 1 Data Set.

How can I accomplish that? Or do I have to do a new report and call this report from there? And how to I do that?

Thanks.

Upvotes: 0

Views: 338

Answers (1)

Jeroen
Jeroen

Reputation: 63830

You're on the right path. However, leave your initial (single-user) report alone. Instead, create a new "master" report with a dataset such as Users that's displayed in a list. In that list add a subreport that shows the info for one individual user. That subreport can be passed parameters and have multiple datasets.

Upvotes: 1

Related Questions