Hi Friends,
Today i'll demonstrate how to create multiple data regions/ groups in SSRS reports. A data region in simple definition is a subreport report that shares the parameters and datasets, and is present inside the report design itself.
- This and the following procedure will help you understand how multiple data regions can be created in SSRS. The first of the two data regions will display the detailed customer transactions.
Note: 1. 1st we have to create a query using CustTrans and CustTable tables and with following fields as shown below.
2. We are using "AutoDesign" report while creating reports.
- Create a PktCustTransList query, which includes the CustTable and CustTrans tables. Remove the unwanted fields and retain only the fields that are shown in the following screenshot:
- Open Visual Studio and create a new Report Model Project named PktCustTransReport and create a dataset that refers to the PktCustTransList query.
- When selecting the fields in the query window, select all the fields and the name data method from CustTable.