Define Column Details

Edit or define column display settings for grids from the Query Data Block's Object pane.

  1. On the Object tab of the Query Data block, click the Column Settings button. Columns defined for the Query will display in the left hand pane.

  1. Select the column you wish to customize or edit from the Columns pane.
  2. If you want to change the column header enter the desired text in the Caption field.
  3. If you want to customize the tool tip for your new column header, enter a Description. This will appear when a user hovers over the column header.
  4. If you want to include a unit of measure for numeric data enter it in the Units field.
  5. If you want the unit of measure to be added to the column header click the Include units in caption check box.
  6. Optionally use the up and down arrows to the right of the Decimal places field to specify how many decimal places you wish to display in a numeric column.
  7. If you wish to restore the column settings to the default settings, click the Restore Defaults button.
  8. Repeat steps 1 -7 for each column you wish to customize.
  9. Click the Done button to save your changes and return to the Dashboard you were editing.