Hi i have 2 questions
1.) What is the difference between SRSReportDataProviderBase and SrsReportDataProviderPreProcessTempDB
like we write
public class myclassDP extends SRSReportDataProviderBase or SrsReportDataProviderPreProcessTempDB
{
}
2.) in SSRS reports while i use My temp table type is it necessary to change its Table Type to TempDB or regular will do.
Preprocessed data providers first prepare all data and only then they call SSRS. Normally the report itself asked for data when needed and if it takes too long, a timeout will kill the execution. Preprocessing data is there to avoid this problem.
Use TempDB with SrsReportDataProviderPreProcessTempDB. Regular tables were used in a previous solution and it caused some performance issues.