Format fields

Descriptions for each of the format attributes that can be applied to a query result column's header, detail and summary cells.

Format
  • As is can be applied to numeric, character, date and time data.
  • Currency can be applied only to numeric data.
  • Decimal can be applied only to numeric data.
  • Scientific can be applied only to numeric data.
  • Percent can be applied only to numeric data.
  • User Currency can be applied only to numeric data.
  • Hexadecimal can be applied only to character data.
  • Binary can be applied only to character data.
  • YYYYxMMxDD can be applied only to date data.
  • MMxDDxYYYY can be applied only to date data.
  • DDxMMxYYYY can be applied only to date data.
  • YYxMMxDD can be applied only to date data.
  • MMxDDxYY can be applied only to date data.
  • DDxMMxYY can be applied only to date data.
  • HHxMMxSS can be applied to time data.
  • Custom can be applied to different data types.
Sample
Shows a snapshot of how the data will be formatted.
Horizontal alignment
From the drop-down list, select how to align data horizontally in the column. Options are:
  • Left
  • Right
  • Center
Vertical alignment
From the drop-down list, select how to align data vertically in the column. Options are:
  • Top
  • Center
  • Bottom
Options
  • Thousands separator can be applied to numeric data. Select this check box to place a thousands separator in numeric values (the symbol is taken from operating system settings).
  • Negative numbers can be applied to numeric data. Select the format for a negative number from the list of available options.
  • Decimal places can be applied to numeric data. Specify the number of decimal places that will be included in the numeric value.
  • Wrap text can be applied to character data. Select the check box to wrap the contents of the cell to the next line within the cell.
  • Separator symbol can be applied to date and time data. From the list of available formats, select one that will be used to format the date or time data. For example, select a slash (/) for date data to format the data as: 03/25/02. Select a symbol to format time data, such as a colon (:). An example is: 12:03:02.
  • 12 hour mode can be applied to time data. Select the check box to display time in a 12-hour interval, such as 03:12:30 PM or 10:05:07 AM. If this check box is cleared, time is displayed in 24-hour format (such as 15:12:06).
Set as default
Sets the current format attributes as the default for subsequent query results. The current settings will remain in effect until you change the default.
Reset to default
Resets the format attributes to the default setting.
The following formats are available for date:
  • YYYYxMMxDD
  • MMxDDxYYYY
  • DDxMMxYYYY
  • YYxMMxDD
  • MMxDDxYY
  • DDxMMxYY
The following formats are available for time:
  • HHxMMxSS
  • HHxMM
The following formats are available for timestamp:
  • YYYYxMMxDD HHxMMxSS
  • DDxMMxYYYY HHxMMxSS
  • YYYYxMMxDD HHxMM
  • DDxMMxYYYY HHxMM
  • YYxMMxDD HHxMMxSS
  • DDxMMxYY HHxMMxSS
  • YYxMMxDD HHxMM
  • DDxMMxYY HHxMM