Command Statement Syntax:
Code: Select all
ALTER TABLE ALIAS() ADD COLUMN copies2 C(4) Replace all copies2 with ALLT(STR(copies_))
In the Label Designer window, pull down the Report menu to Data Grouping. In the Grouping area, in Group Expressions, type in:
IIF(“FIRM” $ endorse,address,sequence)
Double-click on the Detail bar. Note the height of the Detail. Click OK.
Double click on the Group Footer bar. Change the height to match the height of the Detail (so if the Detail height was 1 inch, make the Group Footer height 1 inch).
Hold down the Shift key while double clicking on the Detail bar and this will select all of your address lines (you can also drag a marquee around the address block, or hold down Shift while single-clicking on each line in the template to select all of your address lines).
With all of your address lines selected, drag the group down to the Group Footer band (below the Detail bar; above the Group Footer bar).
Double click on the Detail bar, and change the height to 0 inches.
Following these steps, which put your address block in the Group Footer area and takes those lines out of the Detail area, will make the address print only once per firm bundle.
To add the copies2 field to your template, click on the AB Tool in the toolbar, then draw a box where you want the copies2 field to print.
In the Report Expression window, type in Copies2 then click OK.
Close the template and click Yes to save the changes.