Interactive size in ssrs - Performance Impact

Question

Hi,

In SSRS, we have Interactive Size set to 11 inches by default. If we set it to zero, then all the data is viewed in one page.

https://www.techbrothersit.com/2013/12/ssrs-how-to-display-all-records-on-one.html

As mentioned above, do the Interactive size impact the performance.

In my report, I have set the interactive size height to 455 inches, which is the maximum height.

The no of records are 117,123. It is loading in one page but it is taking a huge time to view the report.

Will reducing the report height, to 30 inches or so, improve the performance?

Need advice on top of this.

Thanks,
Navinkumar Kanagaraj

Answer 1

Hi @Navinkumar Kanagaraj

Base on my understanding ,rendering the report will take a lot of time when the page is so big,so when you reducing the report height ,it will reduce the time loading .

Best Regards,
Isabella

---

If the answer is the right solution, please click "Accept Answer" and upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.