Share via

Is it possible to split a SSRS report into multiple to split the work load

Emir Felek 20 Reputation points
2024-07-25T06:10:43.49+00:00

We have a SSRS Report which has 52 thousand lines the same report on another company has 5 thousand lines. The firstone goes into a timeout and cant be processed and viewed not even with batch processing and email sent.

I am currently searching for a way to split the Report into multiple processes so the workload gets split and the user can still view the report without a timeout but i dont find a way how to.

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,878 questions
Accepted answer
  1. Kiran P 2,190 Reputation points Microsoft Vendor
    2024-07-25T07:22:34.7466667+00:00

    Hi Emir Felek,

    Thank you for reaching out to us on the Microsoft Q&A forum.

    This topic is currently not supported in the Q&A forums.

    I recommend initiating a new discussion through the https://community.dynamics.com/

    Moderators are readily available there to assist you and provide guidance.

    Please don't forget to Accept helpful answer and close this thread.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 35,556 Reputation points
    2024-07-25T08:56:29.15+00:00

    Hi @Emir Felek,

    Large reports present certain processing challenges and require certain configurations if they're to run properly. Large reports shouldn't be run on demand unless they're configured to support pagination.

    • Design the report to support pagination. The report server sends a report one page at a time. If the report includes pagination, you can control how much data is streamed to the browser. For more information, see Preload the cache (SSRS).
    • Configure the report to run as a scheduled report snapshot to prevent it from being run on demand. Don't set a time-out value for report execution. Run the report during off-peak hours.
    • Configure the report to use a shared data source if you want to control whether the report is processed. One advantage to using a shared data source is that you can disable it. Disabling the data source prevents report processing.
    • Disable report history if you want to conserve disk space. To disable report history, clear all the check boxes on the History properties page.
    • Limit access to the report. Configure the report to use item-level security and replace the default role assignments with new ones that allow access to only those users that need it. By default, users can open any report that they can view in the folder hierarchy. Even if you configure a report to run as a snapshot, users who can view the report item in a folder can open the report. If the report is large, it might cause the browser to stop responding when a user opens the report in the web portal.

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments