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.
class CustomerSalesDataProvider extends SrsReportDataProviderPreProcessTempDB
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.