CODEWITHSUNDEEP
reporting-servicesssrs-2008rdl
Craig
Craig

Reputation: 1287

reporting services, have two reports in rdl

I have a SSRS 2008 report that shows some information based on a start date.

I would now like to add another instance of the report to the same rdl, with a different start date.

How can I add a second instance of the same report to the rdl file? There doesn't seem to be a way to copy and paste it in.

The dataset is the same, just a parameter value changes, but both need to be shown on the same report.

Upvotes: 0

Views: 1110

Answers (1)

Jeroen
Jeroen

Reputation: 63729

Your question sounds a little confusing, because you're talking of "a report in an rdl", but an RDL is a report. What you should probably be looking into is creating a subreport. You can create a "master" report that holds the subreport either exactly twice (2 times) or in a list (n times).

The business case around your start date will determine which option is best for you. If you just have a master report with merely two subreports right below eachother, you can hard-code the parameter "start date" for both subreports. In this case you don't even need a data-set in the master report.

If you need or want to be more flexible use the other option with the subreport in a list. You could create a dataset with a column "start date" and bind that to the parameter for the subreport. This way it's easy to extend the setup to show the report three, four, or n times.

In any case, either option allows you to minimize copy/paste action, which is a good thing.

Upvotes: 2

Related Questions