CODEWITHSUNDEEP
reporting-servicesparametersssrs-2008reportingssrs-2008-r2
Dom Vito
Dom Vito

Reputation: 567

How to pass multiple parameters as individual multiple pages on an SSRS report?

I have a report in SSRS that is mostly static, but has a tablix and a couple text boxes that correspond to a query that returns information for an order number. Currently, that query is designed for ONE order number.

What I want is for the report to look as it does now, but with the ability to select multiple order numbers and generate the report for each one, but all at once.

My problem is that the report will try to combine all the fields for all the order nos onto one page. I do not want that; I want each page to look the same, but with the different text boxes and expressions corresponding to the specific order number information.

Please let me know if you need more context or pictures. Attached is a picture of the report. The red circle is where the order specific info will be, and the order number up top is also pulled in.

report Example

Upvotes: 0

Views: 383

Answers (1)

Tab Alleman
Tab Alleman

Reputation: 31775

Here is one way to do this:

Make a new report that is the same size as your existing report, but that has a multi-select parameter for OrderNumber.

Put a List item on the report, with the item size being the size of your existing report.

Put a DataSet on the report that returns one row per OrderNumber selected in the OrderNumber parameter.

Put a subreport in the List Item, and point the subreport to your existing report.

Wire the OrderNumber from the List's DataSet to pass through to the sub-report Order Number parameter.

And I think that should do it. Going off the top of my head, so I may have missed some small thing. Any SSRS sub-report tutorial should be able to guide you the rest of the way.

Upvotes: 0

Related Questions