web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / SSRS report Timeout Dy...
Supply chain | Supply Chain Management, Commerce
Answered

SSRS report Timeout Dynamics 365 Finance and Operations

(0) ShareShare
ReportReport
Posted on by JoshuaRamaditya 135

Hi all,

We have some problem when we try generate report from SSRS. 

if we generate the report with little data, the report is fine. but the problem when we generate report with lots of data, the report is timeout.

this report is our custom report

this issue occurred on production environment.

can we increase timeout in SSRS?

thank you

I have the same question (0)
  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 239,040 Most Valuable Professional on at

    You can't change the timeout, as far as I know. F&O has a different solution for this kind of things - pre-processing data providers. It means that instead of generation the data during printing, you first generate all the data and only then run the report. A slight introduction is under Help prevent long-running reports from timing out.

  • Suggested answer
    István Orosz Profile Picture
    István Orosz 2,137 on at

    It is not a good idea to increase the timeout value, even on the SQL Server reporting service settings, because it is too tempting to repeat it next month also. Try to optimise your report, e.g. using preprocessing, you can find ideas in the blog mentioned by Martin previously.

  • roo Profile Picture
    roo 40 on at

    There is no place for change parameter like timeout for RS in D365 (like in AX2012), really?

    Pre-processing data providers method is not an effective solution, because if we have a report with a lot of data and it is generated more than 10min. it will fail too.

    Maybe someone tried to change such parameter like: TimeDataRetrieval (field in RS tab, ExecutionLogStorage and view ExecutionLog3), but where? Is it possible?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Mallesh Deshapaga Profile Picture

Mallesh Deshapaga 296

#2
Laurens vd Tang Profile Picture

Laurens vd Tang 234 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 145 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Quality order uses default receipt location instead of actual physical receipt location

Product updates

Dynamics 365 release plans