Clever Geek Handbook

Matrix for each page in SSRS

I have a matrix that has over 100 row entries. I want to map to every page in a matrix (not on the final sum of the matrix) as shown in the image below, but got no solution. Is there a solution for this? Thank.

enter image description here

+3


source to share


1 answer


One way to achieve this:

  • Add a rowcounter field in your dataset that has rowans for each datarow

  • Create a Row group in your matrix using rowcounter, as if Group on: Ceiling (margins! RCounter.Value / x) where x is the number of rows you want to set up on the page

  • Create a shared row or group footer.

  • Set up a page break in a group. In page break options: between instances of each group.



Let me know if this solution will work for you yet. I will create a POC to help.

+1


source






More articles:


All Articles