- C# Scripts
- DWH INTERVIEW QUESTIONS
- MS Dynamics AX 2012 R2 Video Tutorial
- Project / Work Support
- SQL SERVER DBA INTERVIEW QUESTIONS
- SQL SERVER DBA Video Tutorial
- SQL Server / TSQL Tutorial
- SQL Server 2016
- SQL Server Scripts
- SSIS INTERVIEW QUESTIONS
- SSIS Video Tutorial
- SSRS INTERVIEW QUESTIONS
- SSRS Video Tutorial
- TSQL INTERVIEW QUESTIONS
- Team Foundation Server 2013 Video Tutorial
- Team Foundation Server 2015 Video Tutorial
- Windows 10
- Windows Server 2012 R2 Installation Videos
SSRS - How To Display All Records On One Page in SSRS
We have created our SSRS Report that consist of multiple pages. Our users do not want to click on next page to see the data instead of that they want to display all the records on one page.
The default Interactive size is set to 11 inches and whatever records can fit into it that is what SSRS display to us.
Let's change the Height to 0 Under InteractiveSize Property under Report properties and deploy our report and see if it is showing all records on one page.
As we can see that the next page button is not available as all the records are shown on one page.
Displaying all the records on one page can take long time to display. You want to make sure you do not have millions of records to shown on a page. In those cases the explorer can crash or can take forever to display. Instead of displaying all the records on one page you might want to increase Height from 11 inches to another number to display more records on each page.