Painting Fields on a Report

Painting a field involves choosing the field type, selecting or defining the field, and defining the field attributes.

The Report Format form indicates alphanumeric fields with uppercase Xs. It displays numeric fields in several ways, depending on the field definition. The following table shows several examples.

Display	Description
ZZZZZZZZ	A numeric field, eight digits long. Uppercase Zs indicate the report suppresses leading zeroes (replaces them with spaces) when it displays the data. For example, it displays the value 00010000 as 10000.
ZZZZZZZ.ZZ-	A signed field, seven whole numbers and two decimal places. The report displays a negative sign (-) to show a negative value and a space to show a positive value.
9,999,999.99CR	A signed field separated by commas. The report displays a credit sign (CR) to show a negative value and spaces to show a positive value. The number nine (9) indicates the report does not suppress leading zeroes when it displays the data.
$,$$$,$$$.99-	The report displays a dollar sign ($) before the first number in the field. For example, it displays the value 100 as $100.00. The report suppresses leading zeroes on a dollar field.
*******.99-	The report replaces leading zeroes with asterisks (*). For example, it displays 100 as ****100.00.
.ZZZ%	A percent field.
ZZ/ZZ/ZZ	A date field.
ZZ:ZZ:ZZ	A time field.