≡ Menu

How to handle long running reports in Dynamics Ax 2012 R3


Consider a scenario that we are listing  sale line for  customers on RDP based report. Data is huge on server and report time out occur.

In Dynamics Ax 2012 R3 provide new class “SrsReportDataProviderPreProcessTempDB”  use this class instead of SRSReportDataProviderBase

For base for this report we please follow below link



If you report is already developed you have to require three changes

Change 1:  RDP report always return table of type TempDB, If not then change it.


TempDbChange 2-Extend the class SrsReportDataProviderPreProcessTempDB instead of SRSReportDataProviderBase.






class CustomerSalesDataProvider extends  SrsReportDataProviderPreProcessTempDB


CustomerSaleTemp _CustomerSaleTemp;



Change 3.  Set report connection to temp data table.

The temp table connection string statement will be look like




Rest of the logic remains same on report.

{ 0 comments… add one }

Leave a Comment