SSRS is restricting excel report to 35 tabs.

Question

SSRS is restricting excel report to 35 tabs (pages). Workingsetmaximum is set to 8 GB. Is there some setting that i can change so that the number of pages is not restricted?

Answer 1

Hi @Avijit Swain,

Thanks for your information.

We can learn the maximum rows per worksheet of Excel from the table in this article.

SSRS is restricting excel report to 35 tabs (pages).

Did you configure the setting of displaying a fixed number of rows per page? If you will preview the report and export it to Excel, you will get an Export Error window when you have requested rows more than the maximum number. I've checked this article; we can limit the number of rows per page of SSRS report:

enter=CEILING(RowNumber(Nothing)/25) where 25 is the number of records to be displayed per page. If you want to display 50 records, then choose 50.

We can also get the information from this official document if you configure the row limitation:

Save the report. When you export it to Excel, it exports to multiple worksheets and each worksheet contains a maximum of 65,000 rows.

You can change the number of pages by configuring the number of records.

In addition, if you want to have continuous report, here is a resolved issue, hope this can help you well.

Feel free to share your issue here.

Best regards,

Lucy Chen

---

If the answer is the right solution, please click "Accept Answer" and kindly 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.

https://docs.microsoft.com/en-us/answers/support/email-notifications