Specifying data format options for quick report columns

You can specify data values format options for individual columns in the Choose a format window.

About this task

To specify data format options:

Procedure

  1. Open the Format page of the Create New Quick Report wizard.
  2. Select a column name from the tree. In the Details area, click the ellipsis (...) next to the Format field.
  3. Select the format of the data values from the Format list. Valid options include:
    The following formats are available for numeric data type:
    • As is - The exact value of the column is displayed without any formatting.
    • Currency - Column values are displayed as currency. The locale settings of the current session determine the currency unit that is displayed.
    • Decimal - Column values are displayed as decimals.
    • Scientific - Column values are displayed in scientific notation.
    • Percent - Column values are displayed as percentages.
    • Custom - Data point values are displayed according to the pattern that you specified in the Pattern field.
    The following formats are available for date data type:
    • As is - The exact value of the column is displayed without any formatting.
    • Database - The date is displayed in the format of the database.
    • Date - Select the date presentation from the available formats.
    • Custom - The date is displayed according to the pattern that you specified in the Pattern field.
    The following formats are available for timestamp data type:
    • As is - The exact value of the column is displayed without any formatting.
    • Database - The timestamp is displayed in the format of the database.
    • Timestamp - Select the timestamp presentation from the available formats.
    • Date - Only the date component of the timestamp is displayed.
    • Time - Only the time component of the timestamp is displayed.
    • Custom - The timestamp is displayed according to the pattern that you specified in the Pattern field.
  4. To include thousands separators with data point values, select the Thousands separator check box.
  5. Specify the number of decimal places that are displayed in the Decimal slaces field.
    A value of '0' indicates that no decimal places are displayed.
  6. Select the format of negative numbers in the Negative numbers list.
  7. Click OK.
    The Choose a Format window closes and control returns to the Create New Quick Report wizard.