SSRS-2005 Repeat Matrix On Each Report Page
I am using two matrix controls in my report. Both use different data sets. I want the first matrix to repeat on all the report pages. Can someone help me with this? Thank you in advance.
November 17th, 2010 7:08pm
what do you want to do with the 2nd matrix and where would it sit on the page compared to the 1st one?Rgds Geoff
Free Windows Admin Tool Kit Click here and download it now
November 17th, 2010 9:03pm
The second matrix sits right below the first one. the dynamic column headers of both matrix are the same. The first one has screening levels to be used for the data presented in the second matrix.
Thanks
SVG.
November 17th, 2010 11:57pm
Hi SVG,
In order to set the first matrix control to repeat on every page, one workaround is to nest the matrix in a repeated table header. However, it requires to merge the 2 datasets to
one at first. If it is possible, please refer steps below after merged:
1.
Add a table to the report. Delete the detail row in the table.
2.
Place the first matrix in the table header and place the second matrix in the table footer,
3.
Set the
RepeatOnNewPage property of the table header to True.
Thanks,
Tony Chain
Please remember to mark the replies as answers if they help and unmark them if they provide no help
Free Windows Admin Tool Kit Click here and download it now
November 19th, 2010 4:26am
Hi Tony,
Thanks for the solution. I will try to merge the datasets.
Thank you,
SG.
November 19th, 2010 4:23pm