- Dedicated trainers
- Maximum 6 per class
- Superb courseware
Phone (01457) 858877 or email
CONTROLLING THE NUMBER OF ROWS PER PAGE IN REPORTING SERVICES
Part one of a four-part series of blogs
Unfortunately, Reporting Services doesn't have a simple setting that allows you to control the number of rows you see on each page. However, you can control this using a clever combination of an expression with a grouping level. Read this blog to find out how!
- Controlling the Number of Rows in Reporting Services (this article)
- Using Groups to Choose the Number of Rows per Page
- How the Ceiling and RowNumber Functions Work
- Using Parameters to Control the Number of Rows
Controlling the Number of Rows in Reporting Services
In Reporting Services when you add a table to a report you have no direct control over the number of records that appear on each page.
In this table of films we get 48 rows on the first page of the report.
Changing the Page Size of a Report
The number of records you see on each page is determined by the size of the page the report uses. You can change the page size of a report by choosing Report > Report Properties... from the menu.
On the Page Setup tab of the dialog box you can change the Paper size: option to alter the number of records per page.
Although changing the page size of the report affects the number of records you see, if you really want to control the number of rows per page you need to use a more sophisticated approach. The next part of this blog series explains how you can use grouping and expressions to set a precise number of records per page.
CONTROLLING THE NUMBER OF ROWS PER PAGE IN REPORTING SERVICES
Part one of a four-part series of blogs
Unfortunately, Reporting Services doesn't have a simple setting that allows you to control the number of rows you see on each page. However, you can control this using a clever combination of an expression with a grouping level. Read this blog to find out how!
- Controlling the Number of Rows in Reporting Services (this article)
- Using Groups to Choose the Number of Rows per Page
- How the Ceiling and RowNumber Functions Work
- Using Parameters to Control the Number of Rows
Comments on this blog
This blog has 3 comments:
i have tried parameter to control no of rows its working by using parent group but in case if i dont need these parent group so what should do for that?
means i need only row column(i want to skip paraent group column) .....i have tried on deatil group but it is not showing proper output.
regards
tejas
Hi,
You can happily delete the column which displays the parent group information - there's no need to display it in the table. I've included it in the screenshots just to make it more clear what's happening.
Hi,
Without seeing what you've done it's a bit difficult for me to guess what might have gone wrong. When this happens to me I always find it best to start again in a fresh report and follow each step carefully.
hi
go to the group properties and then page breaks and checked the "Between each instance of group"
Good luck