ssrs
Hi, I am working in ssrs with visual studio 2008. I have a table with multiple rows and I want to break it into different pages containing selected number of rows. But I am unable to do it. How can I do it ?
July 21st, 2012 3:28am

Hi There Thanks for your posting. You have to make sure that =Ceiling(ROWNUMBER(Nothing)\60) will be your first group inside the tablix which means it must be parent group of your actual first group inside the tablix. This will devide your report per page 60 rows, it depends how many you need just please devide with that =Ceiling(ROWNUMBER(Nothing)\60 ) So please right click on your top group and add parent group and put this expression. Please make sure that sort expression of this group will not be set as by default SSRS set the default sort to the expression of your group Please also make sure to set the page break between each instance of that group A screenshot for your help Please also see Page Breaks section of http://technet.microsoft.com/en-us/library/ms157328(v=sql.105).aspx#PageBreaks If you have any question please let me know. Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful
Free Windows Admin Tool Kit Click here and download it now
July 21st, 2012 3:33am

Hi, Thank you so much for help.
July 21st, 2012 4:59am

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

Other recent topics Other recent topics