Breaking the SSRS report depending on the Multi Value Parameter

4
votes

I am working on a SSRS report with a Multi Value Parameter which contains list of names. I have written an expression for the title that works like "Result for SELECTED NAME". It also have an option of (Select All) which displays all the results with title as "Result for MULTIPLE NAME". It is working fine up to this part.

Now I have to modify the report like, If i select multiple values, the report should break into pages with each selected name on different page with title for that individual parameter value(name) as "Result for SELECTED NAME".

Please help me. Thank you.

2
sqlsql-serverreporting-servicesssrs-2012

2 Answers

3
votes

You can place the entirety of your current report (excluding headers/footers) into a List object. I assume youa re returning the selected values from the parameter (like Manager Name) as part of your DataSet. Assuming this is the case

  1. Create a new list

  2. Insert the contents of your report into the rectangle of this List

  3. Right click the List Row Header and Select Row Group -> Group Properties

  4. Set the Group to Group on 

    =Fields!ManagerName.Value

This approach will take a simple table like this

enter image description here

And break it into a list like this

enter image description here

Then you can just set the Tablix Properties of the List to Add a Page Break After to checked

Hopefully this is helpful. If you have further questions on this then please let me know

1
votes

I worked on it and found a way to make it happen. I first created the row group for Names. Then applied the page break for each instance option. Then deleted that group column (Only deleted column but not group). Then added that group in a static column on the top, and wrote an expressions to show that group itself as a title using concatenation.

But here I faced another problem, when there is no data for the selected name, the title row isn't displayed in the preview as it also a column in the table.