Basic Report Design - Professional SQL Server 2005 Reporting Services - page 82

The Query Builder does one very simple thing: It creates the Transact-SQL expression that you see in the
Query string box in this page of the Report Wizard. If you know your way around Transact-SQL, you
can simply type the expression into this box or into the SQL pane of the Query Builder Window. You can
also go back and make changes if necessary either directly to the query string or using the Query Builder
dialog. In a later example, a stored procedure will be used in place of the query string.
Defining the Report Structure
The following pages will guide you through specifying report design elements such as the style, layout,
data sorting, and grouping. In an effort to keep things simple, specify a Tabular style with all data fields
in a single detail section, as in Figure 4-15.
Figure 4-15
This report will simply be a list of records and is known as a Tabular report. Click the Next button to go
to the next page (shown in Figure 4-16), which is used to design a table control that will display rows
and columns of data. In this simple report, you will not be using any groupings so all four fields will be
added to the Details section.
On the Choose the Table Layout page (not shown,) simply accept the default setting and click the Next
button. This report will be grouped on the SubCategory column. Select this field from the Available
fields list, and then click the Group button. Select the ProductName, ProductNumber, and ListPrice
fields from the Available fields list and click the Details button in that, and then click the Next button, as
shown in Figure 4-17.
The Report Wizard will create controls with coordinated fonts and colors using one of five different themes.
These properties may be modified in the designer later. Retain the default Corporate setting, and click Next.