SSRS - How To Display All Records On One Page in SSRS

Scenario : 

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.


Solution : 

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.
Report display

As we can see that the next page button is not available as all the records are shown on one page.

Note: 
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.

2 comments:

  1. Next time I read a blog, Hopefully it doesn't fail me just as much as this one. I mean, I know it was my choice to read, however I actually believed you would have something useful to say. All I hear is a bunch of complaining about something that you could fix if you were not too busy seeking attention.car shipping indiana

    ReplyDelete