Specifications

www.evisions.com Argos - Argos Report Writers Guide Page 64 of 118
Document Version 1.0 Last Updated 10.18.2010
Group Band on new page/reset counter
Example 5
Introduction
This example illustrates a situation where it is desired to print each group on a new page
and to reset the page number to 1 for each group. The COUNTER and RESETEXPR
functions will be utilized to accomplish this.
Example 1 showed how to reset the SUM and COUNT functions after printing (by selecting
the “Reset after print” check box). For this example the PAGENUMBER function seemingly
could be used to print the page number, however this function cannot be reset. Instead
the COUNTER function is used to count pages since this function can be reset using the
RESETEXPR function when required.
The Employees, Orders, Order_Details, and Products tables within the sample database are
used within this example. The report will list all sales orders per employee as shown
below:
Figure 111The printed report