Microsoft SQL Server 2012 Bible

Building a Report with the Report Wizard

Reports vary in complexity and required design time; however, you can create a quick report by using the Report Wizard inside SSRS. it often speeds development time to get a report foundation by using the wizard, which can then be modified to any further requirements you have.

Imagine that you are the report writer for Adventureworks. You have been tasked with a simple report giving the contact information for all of the resellers of Adventureworks products. You have worked out the following query from the AdventureworksDW database to satisfy the requirements:

SELECT dsr.ResellerName , dsr.Phone
,dsr.AddressLine1, dsr.AddressLine2, dg.City, 
dg.StateProvinceCode , dg.EnglishCountryRegionName ,  
dsr.AnnualSales 
FROM DimReseller dsr
JOIN DimGeography dg ON dsr.GeographyKey = dg.GeographyKey

To create a basic report using the Report Wizard that displays the reseller contact information shown in Figure 55.1, first open the Report Designer in SSDT by going to Start → All Programs → Microsoft SQL Server 2012 → SQL Server Data Tools. SSDT opens. To create a Reporting Services Project, go to File → New → Project. From the New Project dialog box ensure that Business Intelligence is the selected project type, and then select Report Server Project Wizard from the choices of available templates. Name the project AdventureworksReports and select the file location for the project. Click OK.

Figure 55.1 Query result for reseller contact info.

Follow ...