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