SSRS Tip: Creating Multiple Data Regions In SSRS Reports

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.

Procedure: 

Multiple Data Regions can be achieved by following the below mentioned procedure.

Drag the CustTrans dataset to the auto design node. This will create a Table design layout.

The grouping ability of the data regions helps in presenting the data effectively,by ordering and organizing them.

Drag the CustGroup fi eld to the Group on node and then drag the AccountNum field to the Group on node from the dataset.

Expand the Group on node and navigate to the Row property and drag the field's Currency, Party_Name to the AccountNum group node.

Grouping helps in rendering the data in a summarized view. The order of the grouping property determines the order in which they are summarized. In this case, the grouping is done by the customer group followed by the customer:

• Preview the report and see how multiple groupings look in action:

It's done, now Build it, Add to AOT and Build It.

Proud To Be a DAX Developer :-)