web
You’re offline. This is a read only version of the page.
close
Skip to main content
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)
  • roo Profile Picture
    roo 40 on at
    RE: SSRS report Timeout Dynamics 365 Finance and Operations

    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?

  • Suggested answer
    István Orosz Profile Picture
    István Orosz 2,137 on at
    RE: SSRS report Timeout Dynamics 365 Finance and Operations

    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.

  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 236,172 Most Valuable Professional on at
    RE: SSRS report Timeout Dynamics 365 Finance and Operations

    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.

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 1,098

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 215 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans