Specifications

www.evisions.com Argos - Argos Report Writers Guide Page 57 of 118
Document Version 1.0 – Last Updated 10.18.2010
The COPY function returns a substring, and for this example you need to choose the
Employee Last Name field from the database (using the same method as in previous
examples) and return the first character from the string by entering the following:
Figure 98 – Obtaining the first letter of the last name
The expression to return the first letter of the last name has now been inserted into the
Group-by-field or expression box. The grouping is now handled by an expression, as
opposed to an earlier example where grouping was done by a database field name.
Figure 99 – The expression entered into the Group-by-field or expression box
Place Expression into Group Header Band
The final step is to place the same expression into the Group Header such that the first
letter of the last name is displayed within the Group Header. To accomplish this, click
E=mc
2
on the toolbar, then click within the Group Header Band. Then enter the same
expression as before.