October 22, 2007 at 1:44 pm
Does anyone know how to show 10 records a page? For example, let's say I have 100 records contained in a report using the ad hoc report capability in Reporting Services 2005. Rather than scrolling to see all records, I want to see only 10 records per page. Is there a way to do that?
October 23, 2007 at 7:47 am
This is a drawback in SSRS as there is not a way to set paging based on records. If you are doing any grouping you can set each group to be on it's own page. One way to manage the paging is to create a group using the RowNumber function divided by the # of rows on a page and set the group to have page break at the end. You need to be sure to use the "\" operator, which is integer division so records 1-10 return 1, 11-20 return 2, etc...
So our expression in the Group would be =RowNumber([scope])\[Records per Page]
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply