SSRS Tutorial 55- How to Limit Number of Rows per Page by Parameter in SSRS Report

In this video of SSRS Tutorial, You will learn


  1. How to create Tabular Report
  2. How to use RowNumber and Ceiling Function in SSRS Report to build Logic for Row per page Group
  3. How to Create Parameter in SSRS so users can control the Number or Rows per page


Expressions used in the SSRS Report
=Ceiling(RowNumber(nothing)/Parameters!RowsPerPage.Value)



Limit Number of Rows per Page by Parameter in SSRS Report - SSRS Tutorial