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

Announcements

Introducing our New Video Series: Community Spotlight
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 238,601 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

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
André Arnaud de Calavon Profile Picture

Liquid error: Object of type 'Adxstudio.Xrm.Web.Mvc.Liquid.EntityReferenceDrop' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. André Arnaud de Cal... 179 Super User 2026 Season 1

#2
Laurens vd Tang Profile Picture

Liquid error: Object of type 'Adxstudio.Xrm.Web.Mvc.Liquid.EntityReferenceDrop' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Laurens vd Tang 83 Super User 2026 Season 1

#3
Mallesh Deshapaga Profile Picture

Liquid error: Object of type 'Adxstudio.Xrm.Web.Mvc.Liquid.EntityReferenceDrop' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Mallesh Deshapaga 79

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