The Grouping, Filtering and Sorting dialog is used to perform grouping, filtering and sorting on the raw data set, and is organized by tabs (see figure below).
Figure 1: Grouping, Filtering and Sorting dialog.
To open this dialog:
- Double-click on the grouping field, displayed on the control's Category Grouping Field drop zone (see figure below).
- Right-click over the field and select the Properties menu item.
Figure 2: Gauge control's drop zones
 |
You may have specified a data grouping field in the Data Tab of the Gauge Wizard when first creating the gauge, and if this is the case it will be displayed on the control's drop zone in the designer. |
All filtering, grouping and sorting is performed by SQL Server, before the Gauge control receives the data.
Grouping and sorting is only applied to the field the dialog was opened for.
String dialog properties can be either a string constant or a report expression.
The following summarizes the dialog's various tabs:
| Tab | Description |
|---|---|
| General | Used to group data. |
| Filters | Used to filter data. |
| Sorting | Used to sort data. |
See Also
Getting Started
Using The Gauge Control
General Designer
Report Expressions
Code Editor
Using the Gauge Wizard