Format the table fields

Format currency or number fields

  1. Select the appropriate field in the table and select the properties icon ().
  2. In the Basic Settings section, select the three-dot menu icon () next to the Format field.
  3. In the Format Dialog, select Number or Currency from the Type dropdown and set the number of Decimal Places.
  4. Optionally, select the Use 1000 Separator(,) checkbox.
  5. Select OK.
  6. Select Save Report to save your changes.

Format date fields

  1. Select the appropriate field in the table and select the properties icon ().
  2. In the Basic Settings section, enter dd-MMM-yyyy in the Format field.
  3. Optionally, to select a different format, select the three-dot menu icon () next to the Format field and do the following in the Format Dialog:
    1. Select Date from the Type dropdown.
    2. Select the Date format from the dropdown.
    3. Select OK.
  4. Select Save Report to save your changes.