Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

Complete the Wizard



By:

Overview
The Completing the Wizard step of the Report Wizard displays a summary of our choices from the previous dialogs. 

Explanation
The Completing the Wizard step in the Report Wizard will display the dialog as shown below:

You should provide a descriptive name for your report in the Report Name textbox; e.g. ReportWizardExample.  You can click the Preview report check box if you would like to see what your report will look like.  Scroll through the Report summary to review your choices.  If there is something you want to change, click the Back button to revisit the completed dialogs.

Click the Finish button to have the wizard generate your report.  You will now see your report in the Solution Explorer as shown below:

The report will also be displayed in the Report Designer.  Click on the Preview tab to render your report.  A portion of the report is shown below:

We're going to make a couple of changes to the report.  Click on the Design tab; you will see the following:

We're going to put spaces between the words in the heading, make the columns a little wider, and change the format of the sales numbers.  Here are the steps:

  • Click in the report heading between the t and W; add a space; do the same for d and E
  • Click in the ParentProductCategory cell, an Excel-like grid will appear, click between the cells at the top of the grid and drag to widen them; you will see the cursor change to <--> when you hover between the cells
  • Click inside the [Sum(Sales)] column, locate Format in the Properties window and type C0; this will format the cell as currency with no decimals.  If you don't see the Properties window, click the top-level View menu then select Properties Window of click F4.  Repeat for the [Sales] column.

After making these changes the report design should look like this:

Click on the Preview tab to display the report:

You can click on the + icon to the left of the Parent Product Category Names to drilldown to Product Category Name details as shown below:

This completes our tutorial section on the Report Wizard.






More SQL Server Solutions











Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Notify for updates 


SQL tips:

*Enter Code refresh code     



Learn more about SQL Server tools