Specifications

www.evisions.com Argos - Argos Report Writers Guide Page 52 of 118
Document Version 1.0 – Last Updated 10.18.2010
Formatting Numeric Output
Example 2
Introduction
The Banded Report in the previous example shows the sum of salaries without any
formatting, that is, without dollar signs or commas. Instead of printing “Total Sum of
Employee Salaries = 1923000 in the Summary Band, it is desired to print it as $1,923,000.
To format the output you need to edit the field within the Band Editor. Right-click the
field to be formatted which brings up the Edit Expression Field dialog box shown below.
Figure 89 – Choosing the field to be formatted
Selecting/Creating the Format Mask
To format the field, click the ellipsis button to the right of “Format” which brings up the
“Edit Format Mask” dialog box (shown below) that provides options for formatting both
numeric and date fields.
You can select one of the pre-existing formats or create your own mask. To select one of
the pre-existing formats, double-click the desired format shown within the lower window.
The selected option will then appear in the box at the bottom of the window as shown
below. You can also create your own format by using the formatting characters described
at the top of the Edit Format Mask dialog box.
Edit Format Mask
Choose one of the existing formats (double-
click) or enter your desired mask in the text box
at the bottom of the Edit Format Mask dialog
box.