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