Share via

SSRS report when run manually in Reporting Services never finishes. Same report when run via a report subscription runs in less than a minute.

Tom Stone 521 Reputation points
2020-08-29T14:23:28.77+00:00

I created a report subscription for a SSRS report and it runs and is delivered within one minute.
The same report when run manually in Reporting Services never finishes.
The report simply calls a stored procedure which selects from a SQL view.
Both the stored procedure and running the SQL view manually runs in 20 seconds.
What am I missing?

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,835 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 33,946 Reputation points
    2020-08-31T06:19:21.87+00:00

    Hi

    As mentioned in your further question, please check the ExecutionLog3.

    Run the report on the report server for 1-2minutes, and cancel it.

    Open the SSMS. 

    Use ReportServer  
select * from ExecutionLog3 order by TimeStart DESC

    In the executionlog, find this action record.

    Check the itemaction,data retrieval,process and ect to see which action the report stuck on.

    And then we could do further troubleshooting.

    In addition, only one report couldn't finish or all the report?If only this one,please compare the difference with two reports.

    You may also check if other users could run the report successfully.

    I did some research that someone said that the issue was related to the parameters,hope it could give you some ideas.

    For reference: https://community.spiceworks.com/topic/508390-stored-procedure-is-fast-report-is-slow
    https://stackoverflow.com/questions/2283943/fast-query-runs-slow-in-ssrs#:~:text=If%20your%20stored%20procedure%20uses,server%20to%20retrieve%20the%20data.

    Regards,

    Zoe

    0 comments