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
    • Python Programs
    • Java Programs

Creating SSRS Matrix Report using Report Wizard

by suresh

In this article, we will show you the step by step approach for creating SSRS Matrix Report using Report Wizard in SQL Server Reporting Services.

Creating SSRS Matrix Report using Report Wizard

After creating a New SSRS Project, We have three folders in the solution explorer, such as Shared Data Sources, Shared Datasets, and Reports. Reports folder is enough to design a basic SSRS report.

Creating SSRS Matrix Report using Report Wizard 1

When we right-click on the Reports folder, it provides various options to design reports.

  • Add New Report: Open up the Report wizard to design report.
  • Add: Gives us a choice to choose whether we want to design a report using Report Wizard or an empty report.
  • Import Reports: We can import reports from the file system.

Here, we are selecting the first option, Add New Report. Once you click on this option, it will open the Report wizard. The first page is a Welcome screen, If you don’t want to see this page again, Please mark the Don’t show this page again option.

Creating SSRS Matrix Report using Report Wizard 2

Select the Data Source: This page is used to configure the Data Source. Here we have two options:

  • Shared data Source: If you already created the Shared data Source, Please select the data source name from the drop-down list.
  • New data Source: If you haven’t already created the Data Source, Please select this option and create a New data source.
Creating SSRS Matrix Report using Report Wizard 3

If you select the New Data Source, then the following properties will come into play. Please refer to the SSRS Shared Data Source article to understand the properties in detail.

Creating SSRS Matrix Report using Report Wizard 4

Design Query

This page is used to write the SQL Query to extract the data from the Data Source. If you are not familiar with SQL Queries, then click on the Query Builder button. Please refer SSRS Query Designer article to understand the steps involved in designing SQL Queries

Creating SSRS Matrix Report using Report Wizard 5

In this example, we are coping the SQL Query from SQL Server Management Studio to Query String empty space

Creating SSRS Matrix Report using Report Wizard 6

SQL Command we used in the above screenshot is:

SELECT FirstName, 
       LastName, 
       Gender, 
       EmailAddress, 
       YearlyIncome, 
       EnglishEducation, 
       EnglishOccupation, 
       Phone
FROM DimCustomer
ORDER BY FirstName DESC, 
         LastName DESC

Select the Report Type: Please select the Report type you wish to design.

  • If you are designing the Table report, Please select the Tabular option.
  • If you are designing a Matrix report, Please select the Matrix option.
Creating SSRS Matrix Report using Report Wizard 7

Design the Matrix: Properties involved in this page are:

  • Available Fields: List of columns we got it from the SQL Query we designed before
  • Page: If you place anything, it will start a new page for every unique value
  • Columns: If you want to perform any Column grouping operations, then place those columns in this place. Here, We are putting Gender in Column Grouping
  • Rows: If you’re going to perform any Row grouping operations, then place those columns in this place. Here, We are placing English Occupation and English Education in Row Grouping
  • Details: Columns added to this tab will show as output columns in the Table report. We are adding Sales Amount in this detailed tab
  • Remove: This button will remove column names from Page, Grouping, and Details
Creating SSRS Matrix Report using Report Wizard 8

NOTE: Please checkmark the Enable Drilldown option if you want to enable the Drill down operations otherwise, uncheck it

Choose the Table Style: You can select your own style as per your requirements. For now, we are selecting the Corporate style

Creating SSRS Matrix Report using Report Wizard 9

Completing the Wizard: Please provide a valid name for the report and click on the finish button. Here, We assigned SSRS Matrix Report using Report Wizard name as report name

Creating SSRS Matrix Report using Report Wizard 10


If you observe the above screenshot, You can see the SQL Query, Report Type, Data Source, and layout Type details.

Click the Finish button to finish creating the SSRS Matrix report using the report wizard.

Creating SSRS Matrix Report using Report Wizard 11

From the above screenshot, you can observe the Final report with Row Groups and Column Groups.

TIP: If you want to add few more Row or Column Groups, you can add them in Row groups pane or Column Groups pane at the bottom

Click on the Preview button to see the report preview.

Creating SSRS Matrix Report using Report Wizard 12

If you observe the above screenshot, It looks good. Still, there is no Header text for English Occupation and English Education columns. It may confuse the end-user so, Let’s add the header text.

Select the two Grouping cells, and right-click on it will open the Context Menu. Please select the Split Cells option and write the Header names in the Empty text boxes.

SSRS Matrix Report using Report Wizard 1

Click on the Preview button to see the report preview. Now, we can understand the Header Data

Matrix Report using Report Wizard in SSRS 8

TIP: If you uncheck the Enable Drill down option in matrix wizard then, we have to apply manually.

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
  • C Tutorial
  • C# Tutorial
  • Java Tutorial
  • JavaScript Tutorial
  • Python Tutorial
  • MySQL Tutorial
  • SQL Server Tutorial
  • R Tutorial
  • Power BI Tutorial
  • Tableau Tutorial
  • SSIS Tutorial
  • SSRS Tutorial
  • Informatica Tutorial
  • Talend Tutorial
  • C Programs
  • C++ Programs
  • Java Programs
  • Python Programs
  • MDX Tutorial
  • SSAS Tutorial
  • QlikView Tutorial

Copyright © 2021 | Tutorial Gateway· All Rights Reserved by Suresh

Home | About Us | Contact Us | Privacy Policy