Note, before getting started with this lesson there are some prerequisites you should know about. Please read my post Getting Started with SQL Server 2008 to ensure you have everything setup correctly, otherwise you will be missing objects required to get the code here to work correctly.
The most common type of report in existence is a simple table like report, that lists lines of data from your data source. In this lab we’ll create just such a report, and include subtotals.
Step 1. Add the report.
Start by right clicking on the Reports branch of Solution Explorer and adding a new report.
Once you click past the welcome screen, select your shared data source, or create a new one for this report. When you have done so, click the Next button.
For the query, we’ll use:SELECT FiscalYear , ProductCategoryName , ProductSubcategory , TotalAmount FROM Report.V_SubcategoryTotalsByYear
On the next screen, leave the report type as Tabular and click next.
Place FiscalYear and ProductCategoryName in the Ggroup area, and ProductSubcategory and TotalAmount in the Details area, and click next.
On the table layout screen, you can leave it as Stepped, but put a check by the “Include subtotals” option.
Chose a table style, to be consistent with previous labs we’ll again go with Corporate. Click Next.
Give the report a good name. For this lab we can use “Subcat Totals”. Click Finish to complete the report generation.
Step 2. Format the report
In the report designer, you’ll see the columns are all narrow and on the left. Click inside the report grid and the report tables row and column sizing handles will appear. Place your mouse cursor between two of the columns and drag to expand its width.
Now preview the report and you will should see: