Dynamics AX SSRS Error: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond

Sometime this error occurs while running SSRS reports. It is due to long running queries which take too much time eventually reaches to report time out limit before the generation of report. The best solution to handle this issue is to run the report in pre-process so that SSRS fetch and process all the data even before reporting window is started.

To do this you need to do the following changes in reporting objects:

• Change the extended class of the RDP class from SrsReportDataProviderBase to SrsReportDataProviderPreProcess.
• Add the following line in the processReport method of RDP class just after contract class object initialization:
• .setConnection(this.parmUserConnection());
• Locate the table being used as data set in the report and change the properties highlighted in the image below:

• Refresh report Dataset from visual studio only to get the new field createdTransactionId.
• Generate the incremental CIL after deployment of the report.
• Restart SSRS for the changes to take effect and now the report can be run with out the timeout error..