SSRS is restricting excel report to 35 tabs.

Avijit Swain 0 Reputation points
2024-05-01T06:11:37.92+00:00

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?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,949 questions
{count} votes

1 answer

Sort by: Most helpful
  1. LucyChenMSFT-4874 5,060 Reputation points
    2024-05-02T05:40:01.2766667+00:00

    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


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.