Table of Contents

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