The client needed as report that displayed no more than 7 records per page of their report in SQL Server Reporting Services:
When one looks at the page break location options in SSRS 2008, you have 5 options: - None
- Start
- End
- End and Start, or
- Between
Solution:
To create a report that returns only 7 records per page:
- Create a new report, and the required datasource and dataset
- Add a Tablix object to the canvas
- Add the required fields to the tablix
- Click on any cell in the tablix
- Right Click on the Detail Row selection button
- Select Add Group - Row Group - Parent Group
- In the Tablix Group dialog box, in the Group By expression box, enter:
=CEILING(RowNumber(Nothing)/7)
- Press the OK button
This adds a Group 1 section to the tablix, and in the Row Group Section at the bottom of the screen
- In the Row Groups section at the bottom of the screen, select the down arrow of Group 1
- Select the Group Properties
- In the Group Properties dialog box:
- General - Name: Page_Break_Group
- Page Breaks - Between each instance of a group
- Sorting - Select the Sort expression column and press the Delete button
- Press the OK button
- On the tablix, Right click the Group 1 column
- Select Delete Columns
- in the Delete Columns dialog box, select the Delete Columns only
- Press the OK button
The report now only displays 7 records per page
If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us |
