Databases Reference
In-Depth Information
from the way they are returned by the data set, choose the appropriate field expression from the drop-
down list in the first row of the Sort on grid. You may subsort on different field values by choosing sub-
sequent field expressions in multiple rows in this grid.
Figure 6-18
Click OK to close the Grouping and Sorting Properties dialog. Right-click on the detail row handle again
and repeat the same process for the
ProductSubCategory
field.
Adding the fields to the table is a snap. Just drag and drop them from the Dataset window on the left.
Place the
CategoryName
in the first cell in the group 1 row. Drag the
SubCatgoryName
field to the sec-
ond column on the group 2 row, and drag the
ProductName
field to the third column on the detail row,
as shown in Figure 6-19.
Note that the table headers have text added and that the mixed-case field names are parsed appropri-
ately. The report should be functional at this point, although it needs a little cosmetic work. Select the
header row by clicking in the table and then on the header row selector handle. This selects all of the text
boxes in this row. Using the properties window, set the
BorderStyle_Bottom
property to
Solid
and
the
BorderWidth_Bottom
property to
2pt
. Text fonts and styles can be set using the properties window
or the layout toolbar. Using either method, set the
FontWeight
for the text in this row to
Bold
. The
properties window is shown in Figure 6-20.
Finally, remove the unused footer rows. Select the group and table footer rows and then press the Delete
key. What the report looks like in preview is shown in Figure 6-21.
Search WWH ::
Custom Search