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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics