Edit masks
You can select from thirty-three pre-defined edit masks. The following table describes the available masks and
shows how the values 12345678 and -1234567 would be printed for each
mask. In the pattern:
- d is used to represent a decimal digit (0-9)
- w is used to represent a leading sign that will be blank for a positive value or - for a negative value
- x is used to represent a trailing sign that will be blank for a positive value or - for a negative value
- y is used to represent a leading sign that will be blank for a positive value or ( for a negative value
- z is used to represent a trailing sign that will be blank for a positive value or ) for a negative value
| Mask | Pattern | 12345678 | -1234567 |
|---|---|---|---|
| A0 | wddddddddddddddddddddddddddddddd | 12345678 | -1234567 |
| A1 | wd,ddd,ddd,ddd,ddd,ddd,ddd,ddd,ddd,ddd,ddd | 12,345,678 | -1,234,567 |
| A2 | wd.ddd.ddd.ddd.ddd.ddd.ddd.ddd.ddd.ddd.ddd | 12.345.678 | -1.234.567 |
| A3 | wd ddd ddd ddd ddd ddd ddd ddd ddd ddd ddd | 12 345 678 | -1 234 567 |
| A4 | wd'ddd'ddd'ddd'ddd'ddd'ddd'ddd'ddd'ddd'ddd | 12'345'678 | -1'234'567 |
| A5 | d ddd ddd ddd ddd ddd ddd ddd ddd ddd dddx | 12 345 678 | 1 234 567- |
| B1 | wddd,ddd,ddd,ddd,ddd,ddd,ddd,ddd,ddd,ddd.d | 1,234,567.8 | -123,456.7 |
| B2 | wddd.ddd.ddd.ddd.ddd.ddd.ddd.ddd.ddd.ddd,d | 1.234.567,8 | -123.456,7 |
| B3 | wddd ddd ddd ddd ddd ddd ddd ddd ddd ddd,d | 1 234 567,8 | -123 456,7 |
| B4 | wddd'ddd'ddd'ddd'ddd'ddd'ddd'ddd'ddd'ddd.d | 1'234'567.8 | -123'456.7 |
| B5 | wddd'ddd'ddd'ddd'ddd'ddd'ddd'ddd'ddd'ddd,d | 1'234'567,8 | -123'456,7 |
| B6 | ddd ddd ddd ddd ddd ddd ddd ddd ddd ddd,dx | 1 234 567,8 | 123 456,7- |
| C1 | wdd,ddd,ddd,ddd,ddd,ddd,ddd,ddd,ddd,ddd.dd | 123,456.78 | -12,345.67 |
| C2 | wdd.ddd.ddd.ddd.ddd.ddd.ddd.ddd.ddd.ddd,dd | 123.456,78 | -12.345,67 |
| C3 | wdd ddd ddd ddd ddd ddd ddd ddd ddd ddd,dd | 123 456,78 | -12 345,67 |
| C4 | wdd'ddd'ddd'ddd'ddd'ddd'ddd'ddd'ddd'ddd.dd | 123'456.78 | -12'345.67 |
| C5 | wdd'ddd'ddd'ddd'ddd'ddd'ddd'ddd'ddd'ddd,dd | 123'456,78 | -12'345,67 |
| C6 | dd ddd ddd ddd ddd d ddd ddd ddd ddd,ddx | 123 456,78 | 12 345,67- |
| D1 | wd,ddd,ddd,ddd,ddd,ddd,ddd,ddd,ddd,ddd.ddd | 12,345.678 | -1,234.567 |
| D2 | wd.ddd.ddd.ddd.ddd.ddd.ddd.ddd.ddd.ddd,ddd | 12.345,678 | -1.234,567 |
| D3 | wd ddd ddd ddd ddd ddd ddd ddd ddd ddd,ddd | 12 345,678 | -1 234,567 |
| D4 | wd'ddd'ddd'ddd'ddd'ddd'ddd'ddd'ddd'ddd.ddd | 12'345.678 | -1'234.567 |
| D5 | wd'ddd'ddd'ddd'ddd'ddd'ddd'ddd'ddd'ddd,ddd | 12'345,678 | -1'234,567 |
| D6 | d ddd ddd ddd ddd ddd ddd ddd ddd ddd,dddx | 12 345,678 | 1 234,567- |
| E1 | yd,ddd,ddd,ddd,ddd,ddd,ddd,ddd,ddd,ddd,dddz | 12,345,678 | (1,234,567) |
| E2 | yd.ddd.ddd.ddd.ddd.ddd.ddd.ddd.ddd.ddd.dddz | 12.345.678 | (1.234.567) |
| E3 | yd ddd ddd ddd ddd ddd ddd ddd ddd ddd dddz | 12 345 678 | (1 234 567) |
| E4 | yd'ddd'ddd'ddd'ddd'ddd'ddd'ddd'ddd'ddd'dddz | 12'345'678 | (1'234'567) |
| F1 | ydd,ddd,ddd,ddd,ddd,ddd,ddd,ddd,ddd,ddd.ddz | 123,456.78 | (12,345.67) |
| F2 | ydd.ddd.ddd.ddd.ddd.ddd.ddd.ddd.ddd.ddd,ddz | 123.456,78 | (12.345,67) |
| F3 | ydd ddd ddd ddd ddd ddd ddd ddd ddd ddd,ddz | 123 456,78 | (12 345,67) |
| F4 | ydd'ddd'ddd'ddd'ddd'ddd'ddd'ddd'ddd'ddd.ddz | 123'456.78 | (12'345.67) |
| F5 | ydd'ddd'ddd'ddd'ddd'ddd'ddd'ddd'ddd'ddd,ddz | 123'456,78 | (12'345,67) |
| G1 | wddd,ddd,ddd,ddd,ddd,ddd,ddd,ddd,ddd.dddd | 1,234.5678 | -123.4567 |
| G2 | wddd.ddd.ddd.ddd.ddd.ddd.ddd.ddd.ddd,dddd | 1.234,5678 | -123,4567 |
| G3 | wddd ddd ddd ddd ddd ddd ddd ddd ddd,dddd | 1 234,5678 | -123,4567 |
| G4 | wddd'ddd'ddd'ddd'ddd'ddd'ddd'ddd'ddd.dddd | 1'234.5678 | -123.4567 |
| G5 | wddd'ddd'ddd'ddd'ddd'ddd'ddd'ddd'ddd,dddd | 1'234,5678 | -123,4567 |
| G6 | ddd ddd ddd ddd ddd ddd ddd ddd ddd,ddddx | 1 234,5678 | 123,4567- |
To use the E1 edit mask for the Profit field in the previous report, just change ON(28,6,PD) to ON(28,6,PD,E1). The RPT data set looks like this:
07/22/08 Colorado Branches Report - 1 -
City Profit Employees
--------------- --------------------- ----------------
Aspen 5,200 20
Boulder 7,351 32
Denver 6,288 33
Fort Collins (2,863) 22
Vail 5,027 19
Total 21,003 126
Average 4,200 25
Lowest (2,863) 19
Number of cities 5