SSRS uses the Windows Communication Foundation (WCF) to connect to the AOS for data access. This connection has a threshold limit and might fail if a report takes a longer time to execute. The report server execution waits for the RDP to process the data and return. In the event where the RDP takes a longer time to execute the reporting service might fail. Pre-processing is a strategy to beat this issue. This recipe will help you understand how to enable pre-processing for any RDP report.
When a report processes a huge amount of data or is found to take considerable time during execution, you can decide to incorporate pre-processing. Follow these steps to enable pre-processing:
Extend the RDP class from the
SrsReportDataProviderPreProcess
class.Set the following properties in the temp table used by RDP:
Properties
Value
Table Type
Regular
CreatedBy
Yes
CreatedTransactionId
Yes
The crucial portion of RDP is inserting records in the table with the...