Crystal Reports & SQL Reporting Services Training Consultants

Account Log in:

Username:

Password:

*Every person that you meets knows something that you don't; learn from them*

Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers

Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog

April

How Do I Insert a Page Break After a Specific No of Rows in a Table in SSRS?

Recently a couple of my SQL Server Reporting Services clients have asked, how can they add a page break after a specific number of records in a tablix object.

This is a modification of my orginal blog post How Do I Set Number of Records per Page in SSRS?

To give them a bit more flexibility I decided to add a parameter, that allowed them to change the number of records per page

Solution:

Create a new report, and the required datasource and dataset
Create a Parameter field:
- General -
  Name: NoRecords
  Prompt: Enter No of Records Per Page
  Data Type: Integer
  Select Parameter Visibility: Visible
- Default Values -
  Specifiy Value - Value 25
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)/Parameters!NoRecords.Value)
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: