≡ 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

http://tech.alirazazaidi.com/rdp-or-business-logic-based-ssrs-reports-in-dynamics-ax-2012-r3/

 

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.

[

 

SRSReportParameterAttribute(classstr(CustomerSalesDataContract))

]

 

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

 

  _CustomerSaleTemp.setConnection(this.parmUserConnection());

 

Rest of the logic remains same on report.

{ 0 comments… add one }

Leave a Comment