Simple SSRS Report by RDP Class

1. Rdp Class has to extends SRSReportDataProviderBase Class.

2. It Requires one Temp Table, if the table contains more than 1000 records then Table Property TableType should be set to TempDB and if the table contains less than 1000 records then it should be set to Inmemory.

3. Firstly, Create one class which extends SRSReportDataProviderBase Class and in the Class Declaration, declare table buffers which you need including temp table buffer.

4. you can see the sample code below:

5.   class  EmpRdpClass extends SRSReportDataProviderBase

{

TempFilterDemo tempFilterDemo;

FilterDemo filterDemo;

}

6. [SRSReportDataSetAttribute("TempFilterDemo")]

public TempFilterDemo getFilterDemo()

{

    select * from tempFilterDemo;

    return tempFilterDemo;

}

7.  private void insertTmpTable()

{

whileselect * from filterDemo

{

tempFilterDemo.EmplId = filterDemo.EmplId;

tempFilterDemo.Name = filterDemo.Name;

tempFilterDemo.Salary = filterDemo.Salary;

tempFilterDemo.Gender = filterDemo.Gender;

tempFilterDemo.insert();

}

 

}

8 . [SysEntryPointAttribute(false)]

public void ProcessReport()

{

this.insertTmpTable();

}

9. Now you left with SSRS part.