Use the General tab of the Grouping, Filtering and Sorting dialog to group the raw data (see figure 1 below). All grouping is performed on the field that the dialog was opened for.
 

Figure 1: General Tab of 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.

Grouping replaces multiple data rows with one grouped row, according to the grouping expression. In addition grouping on a given column will make all data of the value field available to the Gauge control (without grouping only the first value of the value field would be used, and the control could not display data using formulas).

For more information see the Adding Data topic.

Grouping Name

Determines the name of the grouping, and must be unique for all gauge elements of the report.

By default the grouping name is the control's name, followed by an underscore and then the name of the field (e.g. "dundasGaugeControl_SalesPersonID1").

Group On

Determines the expressions used for grouping. The default expression is the value of the field the dialog was opened for.

Click on a grouping listbox item to set the grouping expression. The values of all available fields will be listed, and clicking on the <Expression...> listbox item will display the Expression Editor, which can be used to create your grouping expression.

For more information see the Report Expressions topic.

Additional expressions can also be added and removed using the  and  buttons, and will be executed in the order by which they are listed.

Use the   and   icons to change the order of the grouping expressions.

See Also

 

 

---

Copyright © 2005 - 2008, Dundas Data Visualization, Inc. and others.