Databases Reference
In-Depth Information
The Grouping and Sorting Properties dialog is displayed with a default name for the new grouping. For
a complex report, you may want to devise a more intuitive naming convention than the one offered by
the Designer. Note this dialog includes the following features:
❑
Name is used for identifying and referring to this group in expressions.
❑
Group on may contain one or more expressions, typically fields, to group on.
❑
Document map label is a field value, an expression, or text that will be used in the document
map for the report.
❑
Parent group may be used to create a hierarchy of nested groupings. This property is not neces-
sary for multiple groups in the same table.
❑
Page break options may be used to force a page break.
❑
Header and footer options enable group header and footer rows.
For simplicity, just add the group field name to the end as you see in Figure 6-17. In the Expression box,
drop down the list from the first row of the grid and select
=Fields!CategoryName.Value
.
Figure 6-17
Switch to the Sorting tab and choose the same field to ensure that records are sorted correctly prior to
grouping on this field value, as shown in Figure 6-18. It's typically a good idea to sort records in the data
set query in the same order they will be presented in the report. However, since grouping and sorting
can be dynamically changed using expressions, make sure that records are sorted in the same order that
they are grouped. Doing otherwise will cause some strange results. If you plan to sort rows differently
Search WWH ::
Custom Search