How to...

You can format currency columns and set defaults for number, date, and time formats.

Related Topics:

  • Define the Default Currency Format for a Report
    To accommodate companies located or doing business in countries other than the United States, DPS provides default formats for currency amounts on reports based on your settings in Regional and Language Options in Microsoft Windows. You can then modify the default formats for individual reports and for individual report columns.
  • Modify the Format for a Currency Column
    The Layout tab in the Options dialog box for a report displays the default currency format for the report. That format is the default format for each currency field on the report. On the Columns tab of the Options dialog box, you can modify the format for individual columns.
  • Define the Default Number Format for a Report
    To accommodate companies located or doing business in countries other than the United States, DPS provides default formats for non-currency numbers on reports based on your settings in Regional and Language Options in Microsoft Windows. You can then modify the default formats for individual reports and for individual report columns.
  • Modify the Format for a Number Column
    The Layout tab in the Options dialog box for a report displays the default non-currency number format for the report. That format is the default format for each non-currency numeric field on the report. On the Columns tab of the Options dialog box, you can modify the format for individual columns.
  • Define the Default Date and Time Format for a Report
    To accommodate companies located or doing business in countries other than the United States, DPS provides default date and time format for reports based on your settings in Regional and Language Options in Microsoft Windows. You can then modify the default formats for individual reports and for individual report columns.
  • Modify the Date and Time Format for a Column
    The Layout tab on the Options dialog box for a report displays the default date and time format for the report. That format is the default format for each date field on the report. On the Columns tab of the Options dialog box, you can modify the format for individual columns.
Parent Topic: Formatting