Value formatting is performed in report builder on any column of a report.
To perform value formatting:
- Go to Report Builder.
- Hover on the column where you want to perform the value formatting.
- Select the down arrow. The column context menu appears.
- Select Format Column. The Format dialog appears.
- Select Value Formatting tab
- Select the required formatting options, see table.
- Select OK.
- Select SAVE to save the report. The applied value formatting displays in view mode of the report.
Formatting options
Different formatting options are available for different types of columns
Text | Number / Autonumber | Decimal / Currency | Date | Date and Time | Time |
|---|---|---|---|---|---|
Alignment
| Alignment
| Alignment
| Alignment
| Alignment
| Alignment
|
| Lines | Prefix | Decimal Places | Date Format (with examples)
| Date time format (with examples)
| Time format (with examples)
|
| Suffix | Prefix | ||||
| Suffix |