Table of Contents

SSRS - Group

About

Grouping management in SSRS.

Expression

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

=Sum(Fields!FieldName.Value, "Group Name") 
=Sum(Fields!SalesAmount.Value, "Product_Category") 
=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

Ssrs Group Pane

Ssis Group Context Mneu