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

Reputation: 567

Selecting multiple parameters for a report, how to create multiple pages per item in parameter list?

I have a report that is a form per order number selected prior to running report. I want to make it so that you can select multiple order_nos from a list (populated by a query that runs first). Right now, it throws an error saying ANY or ALL must be used. I think it is trying to use both order_nos as the parameter for the report. I want it to create the report using just one of the order_nos at a time, and just replicate the report several times. Is this possible?

The attached photo shows what I tried to do and the error thrown.

Error

Upvotes: 0

Views: 149

Answers (1)

Kalim
Kalim

Reputation: 485

If you want to create completely separate outputs then you will need to do this by creating a data driven subscription for your report.

The subscription will execute your report iteratively for each record produced in a preset master query that you create.

Each record in your master query should return all the order no's you wish to execute the report for.

However, if the report needs to remain interactive, and the order no's is only decided at runtime. Then i suggest you keep your report as is. Put a grouping on your tablix based on order no then apply a page break per group instance.

This will produce a single report output with each order no appearing on a different page.

As said above if you want a completely separate output (multiple excel/pdf file outputs) then you will need to use a data driven subscription.

If you need detailed steps on how to do either of the above then just let me know here and i can include steps.

Upvotes: 0

Related Questions