How to get multiple pages in same report in SSRS

2
votes

I created one report, and created a parameter with dimension column, my requirement is when i enter one parameter report should filter with that value when i enter two parameters report should have two pages based on the two parameter values.

any section related thing available in ssrs?

I referred here, something can be done through list, but list is allowing only test boxes, My report has too many tablixs to show

Thanks

Regards

1
reporting-servicesssrs-2012
I believe you could simply add a new tablix below your first one and use the PageBreak property to force the second page. Then you could define an expression that determines visibility of this second table based on the second parameter's value. – Oceans

1 Answers

0
votes

Create a grouping in your tablix, this grouping should be based on the parameter dimension you mention in your question.

Once that is complete, set the tablix to page break for every different instance of the group. This will create a new page for each item in your parameter list.

In this question i gave a similar answer, with some detailed steps: SSRS Report separate data into multiple sheets

This should be applicable to your question as well.