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.
The Add New Report option automatically opens the report wizard with the following welcome page. Click the next button to continue.
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.
The Sql query that we use for this SSRS example is:
SELECT [FirstName]
,[LastName]
,[BirthDate]
,[MaritalStatus]
,[Gender]
,[EmailAddress]
,[YearlyIncome]
,[EnglishEducation]
,[EnglishOccupation]
FROM [dbo].[DimCustomer]
Select Tabular as the report type and click Next.
The next page is to design the table with the available fields.
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.
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.
Change the default report name and click the Finish button.
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.
In the report preview, you can see a little plus button beside each Education column because we checkmark the Enable Drilldown option.
Right-click the Yearly Income column and choose Add Total to add the Sub totals.
You can see the SSRS table report using wizard with grouping, subtotals, and drill down action.
