The options in the Display page of this dialog are:

• Total type: this option, which is only available for values fields, allows you to specify whether a total ("sum"), count, average, highest, or lowest value appears for this field. Choose the desired function from the drop-down list.

• Display date as: this option, which is only available for date fields used as categories or series, allows you to specify whether the actual date is displayed ("Date") or whether the results are summarized by month, quarter, or year. Choose the desired function from the drop-down list.
  

The options in the Format page of this dialog, which only appears for values fields, are:

• Use default format: if this option is turned on, which it is by default, Stonefield Query uses the defined format for the field. If the format for the field changes in the future, the report uses the new format automatically. If you wish to change any of the formatting options, turn this setting off.

• Show commas: this option is only available for numeric data fields or if the Total type option is set to Count. If this option is turned on, the values in the field are formatted with the thousands separator defined in the Regional Settings applet of the Windows Control Panel.

• Display $ (the appropriate currency symbol for your system is displayed in place of "$"): turning this option on displays the currency symbol defined in the Regional Settings applet of the Windows Control Panel in front of the field's value.

• Decimal places: the number of decimals to display.
  

The Comments page shows any comments about the field, which is often used to provide a description of the field's contents.