Grouped Table Using SSRS Report Wizard

This SSRS article shows how to create a grouped table using a report wizard with an example. For this example, we use the shared data source pointing to Adventure Works DW 2019. 

Create a Grouped Table Using SSRS Report Wizard

In the Solution Explorer, right-click on the Reports folder and select Add New Report option from the context.

Add New Report option

The Add New Report option automatically opens the report wizard with the following welcome page. Click the next button to continue.

Welcome Page

You can either use the shared data source you created earlier or create the new one here. We now use the shared data source pointing to Adventure Works DW.

Shared data Source

The Sql query that we use for this SSRS example is:

SELECT [FirstName]
      ,[LastName]
      ,[BirthDate]
      ,[MaritalStatus]
      ,[Gender]
      ,[EmailAddress]
      ,[YearlyIncome]
      ,[EnglishEducation]
      ,[EnglishOccupation]
  FROM [dbo].[DimCustomer]
SQL Query

Select Tabular as the report type and click Next.

Select tabular

The next page is to design the table with the available fields. 

Design Table

In this example, we want to create a grouped table report. So, add the English Education column to the Group section for grouping, and add the remaining fields to the details section.

Grouped Table Using SSRS Report Wizard Fields

Next, you can choose either a Stepped or Block Table Layout. Finally, let me checkmark the Enable Drilldown, and if you want totals, checkmark the Include subtotals option.

Grouped Table Layout Using SSRS Report Wizard

Change the default report name and click the Finish button.

Add Name to Grouped Table Using SSRS Report Wizard

Now you can see the auto-generated grouped table report from the SSRS wizard. You can notice the English Education column under the Row groups section.

Let me do some quick formatting to the Table font and colors.

Auto generated Grouped Table Using SSRS Report Wizard

In the report preview, you can see a little plus button beside each Education column because we checkmark the Enable Drilldown option.

Grouped Table Using SSRS Report Wizard Preview

Right-click the Yearly Income column and choose Add Total to add the Sub totals.

Add Totals to Grouped Table Using SSRS Report Wizard

You can see the SSRS table report using wizard with grouping, subtotals, and drill down action.

Grouped Table with subtotals and grand totals Using SSRS Report Wizard