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"), average, highest, lowest, count, or count distinct value appears for this field. Only Count and Count Distinct are available for non-numeric fields.

  The difference between Count and Count Distinct is that Count counts the number of records while Count Distinct counts the number of records having unique values on this field. For example, if there are 100 order records but all orders were placed this week, using Count on the Order Date field would display 100 but Count Distinct would display 7 (assuming at least one order was placed every day this week).

  Set Total type to None if, instead of displaying summarized values, you want individual values charted. For example, the following chart has Total type set to None, so you can see two orders on 07/08:

  

  The following chart has Total type set to Sum so the total of orders for 07/08 is displayed instead:

  

• 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 hour, week, month, quarter, or year. Choose the desired function from the drop-down list. Note that if you choose "Week," the Week starts on setting in the Options dialog determines which day a week starts on.
  

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 1000 separator: 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.