Creating a report with multiple data sources in a single table

In this recipe, we will create an SSRS report using the RDP concept with multiple data sources. The process method of the RDP class is used to write the business logic in the report and to insert the data into the temporary table. In the previous recipe, we took only one temporary table, but in this recipe, we will take one more temporary table and use both the temporary tables in a single table in the SSRS report.

How to do it…

1. The first step is to create a new temporary table called PktItemTableTmp with the fields indicated here:

   

2. Now we will insert the data into this temporary table in the RDP class. Add another line of code in the ProcessReport method.

   this.insertItemTmpTable(inventBatch,  inventTrans);

3. Add a method in the RDP class named insertItemTmpTable, which is used to insert the data into PKTItemTableTmp invoked from the ProcessReport method:

   privatevoid insertItemTmpTable(
       InventBatch         _inventBatch,
       InventTrans...