562 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
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!
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.
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.
|Parts of this blog|
25 Aytoun Street