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


    Choose :
  • OR
  • To comment
No comments:
Write Comments

Probabilmente come studente universitario ti troverai a scrivere una o più tesi per il tuo analogo esame di fine carriera. Ma di cosa si tratta in particolare? Scopriamo quali sono i pro dei tool per riscrivere testo che troverai online. Per strumento di parafrasi si intende un tool online che si occupa di parafrasare in maniera immediata frasi oppure interi paragrafi. Questa attività si svolgerà interamente su internet e non lascerà alcuna traccia di plagio