SSRS Table using Report Wizard Page and Details

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

SSRS Table using Report Wizard Page and Details

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

Add New Report option

It opens the report wizard with the welcome page. Click the next button to continue.

Welcome Page

Select the shared data source you created earlier or create a new one. Here, we choose the Adventure Works DW shared data source.

Shared data Source

The Sql query we use in the SSRS design query section is:

SELECT Geo.EnglishCountryRegionName AS Country, 
       Geo.StateProvinceName AS State,
	   Geo.City,
       SUM(Fact.OrderQuantity) AS Orders, 
       SUM(Fact.TotalProductCost) AS ProductCost, 
       SUM(Fact.SalesAmount) AS Sales, 
       SUM(Fact.TaxAmt) AS Tax
FROM FactInternetSales AS Fact  INNER JOIN DimCustomer 
      ON DimCustomer.CustomerKey = Fact.CustomerKey
	  JOIN DimGeography AS Geo ON DimCustomer.GeographyKey  = Geo.GeographyKey
GROUP BY Geo.EnglishCountryRegionName, Geo.StateProvinceName, Geo.City
Sql Query for DataSet

Select Tabular as the report type and click Next.

Choose Tabular Report Type

We have to design the table with the available fields on this page. Here, we added a Country to a Page section, which will display each Country on a separate page. So, for instance, the United Kingdom page will have records belonging to the UK. Next, add the remaining fields to the Details section to create a table.

SSRS Table using Report Wizard Page and Details Columns

Change the default report name and click the Finish button.

Name the SSRS Table using Report Wizard Page and Details

Now you can see the auto-generated SSRS table report using the wizard page and details option.

Auto-Generated SSRS Table using Report Wizard Page and Details

The report preview shows a Canada page, and all the cities belong to Canada and its sales.

SSRS Table using Report Wizard Page and Details Preview

Similarly, if you go to the 3rd page, it shows states belonging to France.

Another SSRS Table using Report Wizard Page and Details Preview