Tutorial Gateway

  • C
  • C#
  • Java
  • Python
  • SQL
  • MySQL
  • Js
  • BI Tools
    • Informatica
    • Talend
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • R Tutorial
    • Alteryx
    • QlikView
  • More
    • C Programs
    • C++ Programs
    • Go Programs
    • Python Programs
    • Java Programs

Grouping in SSRS Matrix Reports

by suresh

In this article, we will show you how to Add Row Groups and Column Groups to already created Matrix Reports in SSRS. We are going to use the below-shown report to explain, Grouping in SSRS Matrix Reports.

Please refer SSRS Matrix Report, Data Source, and Dataset articles to understand the creation of Data Source, Dataset, and SSRS Matrix report. If you observe the below screenshot, It was a standard Matrix report with State Column as Row Group and Occupation as Column Group.

MATRIX REPORT IN SSRS 2014

Add Grouping in SSRS Matrix Reports

In this example, we are going to add a Country column to the Row Grouping and Gender column to Column Grouping. We can add the Column names to the Matrix Grouping in multiple ways:

  • We can drag and Drop the Column name from Report data to the Row Grouping Pane or Column Grouping Pane in the position we want. For example, Drop the column name on top of the existing group to add parent grouping in SSRS.
  • We can Drag the Column name from Report data to the Row Grouping or Column Grouping Column. For example, Drop the column name beside the existing group to add parent grouping.
Row Grouping in SSRS Matrix Report 1

NOTE: It is not a good practice to use the above method. Because if you change the direction of a Blue bar, it will give the wrong result.

The third method to add grouping in SSRS Matrix Reports, go to Row groups pane and right-click on the State Group, will open the context menu. Please select Add Group, and then select the Parent Group option. If you want to add a child group, select the Child Group option.

Row Grouping in SSRS Matrix Report 2

Once you select the Parent Group option, a new Tablix group window will be opened to configure the grouping.

  • Group By: Here, you have to specify the grouping column name. Either you can select the column name from the drop-down list or else click on the fx button to create an expression. In this example, we are adding Country as Grouping column so we selected the same from the list
  • Add Group Header: Please check mark this option, If you want to add a header to this group
  • Add Group Footer: Please check mark this option, If you want to add Footer to this group
Row Grouping in SSRS Matrix Report 3

Click Ok to finish Adding Row Grouping to existing SSRS Matrix.

Add Column Grouping in SSRS

Goto Column groups pane and right-click on the Occupation Group will open the context menu. From the context, Please select Add Group and then select the Parent Group option. If you want to add a child group, select the Child Group option.

Column Grouping in SSRS Matrix Report 1

In this example, we are adding Gender as Column Grouping column, so we selected the same from the list

Column Grouping in SSRS Matrix Report 2

Click Ok to finish Adding Column Grouping to existing SSRS Matrix. From the below screenshot, see that we added Row groups and Column Groups to the existing Matrix. And we also did some Formatting as well.

Grouping in SSRS Matrix Report 1

Click on the Preview button to see the report preview

Grouping in SSRS Matrix Report 4

Placed Under: SSRS

  • Learn SSRS in 28 Days
  • Create New SSRS Project
  • Create a New SSRS Report
  • SSRS Query Designer
  • SSRS Shared Data Source
  • SSRS Shared Dataset
  • SSRS Embedded Dataset
  • SSRS Embedded Data Source
  • SSRS Lookup – combine datasets
  • SSRS Report Items
  • SSRS Table Report
  • SSRS Table using report wizard
  • Format SSRS Table Report
  • SSRS Matrix Report
  • SSRS Matrix with report wizard
  • Display Image in SSRS Report
  • Add Rectangle to SSRS Report
  • Add TextBox to SSRS Report
  • Create a SSRS List Report
  • Grouping in SSRS Matrix Reports
  • Grouping in SSRS Table Reports
  • Create SSRS Report using Views
  • SSRS report with store procedure
  • Add Total and Subtotal to Report
  • Add Headers & Footers to Report
  • SSRS Global References
  • Export Report to PDF, XML, Excel, Word
  • Format SSRS Table Report
  • Format Textbox Fonts & Bg Color
  • Format Numbers in SSRS Report
  • Format SSRS Report Date, Time
  • Add Row Numbers to Report
  • Headers Visible While Scrolling
  • Repeat Headers on Each Page
  • SSRS Sorting
  • SSRS Interactive Sort
  • Filters at Dataset Level in SSRS
  • Filters at Tablix Level in SSRS
  • Page Breaks in SSRS Report
  • Custom Code in SSRS Report
  • SSRS Calculated Fields
  • SSRS Dashboard Reports
  • SSRS Document Map
  • SSRS Drill Through Reports
  • SSRS Drill Down Reports
  • SSRS Drill Down Matrix Report
  • SSRS Go To URL Action
  • SSRS Subreports
  • SSRS Report Parameters
  • SSRS Cascading Parameters
  • SSRS Multiple Parameters
  • SSRS Multi Value Parameter
  • SSRS Drop Down List Parameters
  • SSRS Charts
  • SSRS Area Chart
  • SSRS Bubble Chart
  • SSRS Column Chart
  • Format SSRS Column Chart
  • SSRS Data Bars
  • Data Bars in SSRS Matrix Reports
  • Format SSRS Data Bars
  • SSRS Funnel Chart
  • SSRS Linear Gauges
  • SSRS Radial Gauges
  • Format SSRS Gauges
  • SSRS Indicators
  • Format SSRS Indicators
  • SSRS Line Chart
  • SSRS Pie Chart
  • Format SSRS Pie Chart
  • SSRS Pyramid Chart
  • SSRS Range Chart
  • SSRS Radar Chart
  • SSRS Scatter Plot
  • SSRS Sparkline
  • SSRS Stacked Bar Chart
  • SSRS Configuration Manager
  • Change Report Manager Title
  • SSRS Deploying Reports in BIDS
  • Deploy using Report Manager
  • SSRS Report Manager Shared DataSource
  • SSRS Cached Reports
  • SSRS Linked Reports
  • SSRS Report Parts
  • SSRS Report Snapshot
  • SSRS Report History Snapshot
  • SSRS Report Subscription
  • SSRS Security
  • Upload File to Report Manager
  • Install SSRS Report builder
  • Report Builder – Create a Report
  • Report Builder – Create a Dataset
  • Report Builder- Create Bar chart
  • Report Builder – Create Pie Chart
  • Report Builder – Create report without wizard

Copyright © 2021ยท All Rights Reserved.
About | Contact | Privacy Policy