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 Add New Report option.
It opens the report wizard with the welcome page. Click the next button to continue.
Select the shared data source you created earlier or create a new one. Here, we choose the Adventure Works DW 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
Select Tabular as the report type and click Next.
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.
Change the default report name and click the Finish button.
Now you can see the auto-generated SSRS table report using the wizard page and details option.
The report preview shows a Canada page, and all the cities belong to Canada and its sales.
Similarly, if you go to the 3rd page, it shows states belonging to France.
