SSRS report violation depending on Multi Value parameter

I am working on an SSRS report with a Multi Value parameter that contains a list of names. I wrote an expression for a title that works like "Result for SELECTED NAME". It also has an option (Select All), which displays all results with a heading like "Result for MULTIPLE NAME". It works great with this part.

Now I need to modify the report, as if I had selected several values, the report should be paginated with each name selected on another page with a heading for this individual parameter value (name) as "Result for SELECTED NAME".

Please help me. Thanks.

+4
source share
2 answers

You can place your entire current report (excluding headers and footers) in the list object. I assume that you are returning selected values ​​from a parameter (e.g. manager name) as part of your DataSet. Assuming this is so.

  • Create a new list

  • Paste the contents of your report into the rectangle of this list.

  • Right-click the row list header and select a row group -> Group Properties

  • Set group for group work

    =Fields!ManagerName.Value
    

This approach will take a simple table like this

enter image description here

And break it down into a list like this

enter image description here

Then you can simply set the tablix properties of the list Add a Page Break Afterto check

Hope this helps. If you have further questions about this, please let me know.

+3

. . . ( , ). , .

, , , .

+1

Source: https://habr.com/ru/post/1620618/


All Articles