Page History
...
Option | Description | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Display Name | To change the display name of the column from the default value simply update this field. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Format | Each data type will have a unique set of format options - eg Text, Date or Numeric. The option details are listed below. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Sub Format | Depending on the format option you have chosen for the column above you will have a separate set of sub format options. Select the appropriate sub format option. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Date Other | If you select 'Other' from the date sub format you will be able to build your own custom date format. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Decimal Places | If you have a defined a numeric format you can set the number of decimal places to be defined. This can be used to define cents in a decimal place for $20.00 by adding in:2
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Prefix | The prefix is used to include additional characters before the value that is returned from the data base. This can be used to define currency for $20.00 by adding in: $ | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Suffix | The suffix is used to include additional characters after the value that is returned from the data base. This can be used to define percentage for 30% by adding in: % | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Rounding | The rounding format allows you to choose how a decimal value should be rounded.
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Thousand Separator | Turns the defaulted thousand separator for your instance on or off. For example: | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Show Field | To hide the column from the report, select this item. By hiding a column the data presented on the page is not re-grouped which would occur if you removed the field from your report. For Example:
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Suppress Duplicates | The suppression of duplicate option will remove duplicate values from a column and group the values under a single value. |
...