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
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.
Change 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.