Jan 1, 2016

Paging in SSRS

Paging is used to display N no. of records per page.  In this post, you will see step by step example of implementing paging in SSRS.

Basic steps to implement paging in SSRS are:
  • Create a simple Tabular Report
  • Create a column S.No which generates an incremental number using RowNumber function
  • Grouping using function to display N records on each page.

Let's create a report to see
For this, we will continue on a Tabular Report we created in an earlier article.

Step 1: Create a simple Tabular Report

First Create a simple Tabular Report using above link. Report looks like below.

Paging-01

Step 2: Create a column S.No with RowNumber
  • S.No column would generate an incremental number.
  • Expression : RowNumber(Nothing)
How to add S.No Column using RowNumber

Paging-02

Step 3: Grouping using function to display N records on each page.
  • Right click Data Region, Then Add Group>Parent Group
Paging-03

  • Click fx and write below Formula in Expression window

Paging-04

Paging-05

Note: At this state if you will run the report you will get below error

Paging-06
To overcome this error, we need to delete Sort Expression in Group Properties

Right Click Group > Group Properties

Paging-07

Select Sorting Tab and delete the existing Sort Expression appearing in the below screen

Paging-08

Select Page Breaks Tab and select the option Between each instance of a group

Paging-09

We are done with implementing paging at this state. Let's run the report and check the output

Output of the Report
Page 1
Paging-10
Page 2
Paging-11

Group1 column is not required in the ouptut, so you can right Click and delete this column using Delete Columns only option

Paging-12