Two Matrix objects Page Breaking
Hi All: I'm using SSRS 2008 SP1. My challenge is that I have two matrix objects in the body of my report each grouped on DocID; matrix 1 is on top and matrix 2 below. I'd like to show only the data relative each DocID per page. How do I get each matrix to stay together but page break after each new docid in matrix 2. For example: (Matrix1) Dr.Gates, Total Labs (Matrix2) Dr.Gates Total Orders New Page (Matrix1) Dr.Buffet, Total Labs (Matrix2)Dr. Buffett, Total Orders New Page ...... Thanks Pat
July 19th, 2012 10:53am

Hi PatSaturday, Follow these steps to achieve your required results: 1. Use List component of SSRS on the Body 2. Put your 2 Matrix(Tablix) inside this list 3. Add row group to List component and in row group, set group by <Dr. Name> column Screen-shot for reference: Thats it :) Enjoy Thanks, Khilit http://www.bigator.com
Free Windows Admin Tool Kit Click here and download it now
July 19th, 2012 11:31am

Perfect Thanks Khilit.
July 19th, 2012 2:09pm

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

Other recent topics Other recent topics