[Microsoft BI] Grouping And Sorting

 

Grouping and sorting

 

Grouping

 

In a data region, you can group data by a single field, or create more complex expressions that identify the data on which to group. Complex expressions include references to multiple fields or parameters, conditional statements, or custom code.

 

Grouping Data in SSRS

1. Right click on table and go to properties. It opens a new window. 
2. In table properties window switch to Groups tab, and then click Add button.

 

 

      3. You will find an another window for Grouping and Sorting properties

     4. Undergroup on section select an expression, on which you want to group data.

    5. If you want to group data with in another group you can select group expression for parent group. 

Interactive Sprting:

Adding dynamic sorting

It is incredibly easy to add sorting to the table. Open any report which contains the table. Navigate to the Layout tab of the report designer. Click in the cell labeled First Name in the header of the table. Right-click and select Properties.

  Switch to the Interactive Sort tab. Check the checkbox for 'Add an interactive sort action to this textbox'. Next, set the Sort expression to the value that is displayed in the column – in this case =Fields!FirstName.Value. Now repeat this process for the rest of the report. 

Preview the report, and you should have interactive sorting on each column.