Thursday, April 3, 2014

Table 'TableName' used in report provider class should be a regular table.

This is because the RDP class extends the SRSReportDataProviderPreprocess class. to resolve this, you can do following steps:

1. Replace SRSReportDataProviderPreprocess with SRSReportDataProviderBase, but you will not be able to debug the report if it extends from SRSReportDataProviderBase.

2. Change properties of the report's tmp table CreatedBy and CreatetransactionId to 'yes', Also make the table as regular table.