Filter
Top Products
CHAPTER 8 Displaying and Validating Data
DataWindow Designer User’s Guide 231
Shortcuts
To assign the Currency or Percent display format to a numeric column in a
report, select the column, then click the Currency or Percent button in the
PainterBar or select Format>Currency or Format>Percent from the menu bar.
Customizing the
toolbar
You can add buttons to the PainterBar that assign a specified display format to
selected columns in reports.
For more information, see “Customizing toolbars” on page 23.
Defining display formats
Display formats are represented through masks, where certain characters have
special significance. DataWindow Designer supports four kinds of display
formats, each using different mask characters:
Numbers
Strings
Dates
Times
For example, in a string format mask, each
@ represents a character in the
string and all other characters represent themselves. You can use the following
mask to display phone numbers:
(@@@) @@@-@@@@
Combining formats
You can include different types of display format masks in a single format. Use
a space to separate the masks. For example, the following format section
includes a date and time format:
mmmm/dd/yyyy h:mm
Using sections
Each type of display format can have multiple sections, with each section
corresponding to a form of the number, string, date, or time. Only one section
is required; additional sections are optional and should be separated with
semicolons (;). You cannot use sections in edit masks. Semicolons can be used
only in display formats.
The following format specifies different displays for positive and negative
numbers—negative numbers are displayed in parentheses:
$#,##0;($#,##0)