Display All Records on Single Page in SSRS

Display all Record in SSRS on single page instead of Multiple Pages.

Before

Change Property of Report

Change Interactive Size Height to 0in

 

 

You might get following error message.

This is due to Performance impact. If  you have huge number of record it is not recommended to change page size and keep it on single page.


After

 

 



 

 



SSRS Expression to change Total Number of Pages on Top

SSRS Expression to show total number of Pages

-- Drag Text Bot in Page Header
--Use following Expression

="Page " & Globals.PageNumber & " of " & Globals.TotalPages

Before Expression

After Expression