SSRS - Group

Ssrs Report Designer Pane

About

Grouping management in SSRS.

Expression

Group names can be used in expressions to specify scope for aggregated values.

  • Sum by group:
=Sum(Fields!FieldName.Value, "Group Name") 
=Sum(Fields!SalesAmount.Value, "Product_Category") 
  • Sum of Sum by
=Sum(Fields!SalesAmount.Value) & " of " & Sum(Fields!SalesAmount.Value, "Product_Category") 

Row Type

Row Group

Ssrs Row Group

Row Detail

By default, SSRS will create a detail group which is a group without grouping column.

Ssrs Detail Grouping

Management

Group Pane

How to show the group pane:

Ssrs Grouping Pane From Menu

Create / Delete

  • Group pane:

Ssrs Group Pane

  • Group context menu:

Ssis Group Context Mneu

  • Drag a column in the group pane





Discover More
Ssrs Report Designer Pane
SQL Server - Reporting Services (SSRS)

SQL Server Reporting Services (SSRS) is a platform for creating, publishing, and managing reports from Microsoft. SSRS competes with Crystal Reports, BI Publisher and other business intelligence tools,...
Ssrs Hierarchy
SSRS - (Hierarchy|Drill Down)

A hierarchy is defined within the group functionality. In the Group Properties, on the Visibility tab, select Hide, select “Display can be toggled by this report item”, and select the parent group....



Share this page:
Follow us:
Task Runner