Generating Reports › Generating the Bottom Line › Including Report Functions in Footings

Including Report Functions in Footings

The functions available to obtain values for individual fields are included on the Detail fill‑in. The Function column provides for total, average, maximum, and minimum values. By default, the requested values print in summary form or annotated form at each control break level. You can also obtain and print these values in the page or control break footing by specifying them on the Heading fill‑in.

A function request on the Heading fill‑in overrides any requests for the same information on the Detail fill‑in. Any other function specifications on the Detail fill‑in are not affected. Similarly, specifications on the Heading fill‑in do not have to coordinate with specifications on the Detail fill‑in.

For example, a report is to print the total amount outstanding for all customers in each state in the control break footing. CUSTOMER.STATE is defined as a level‑1 control break. The total function was not specified on the Detail fill‑in. It is specified on the Heading Fill‑in to obtain the total value of CUSTOMER.OPEN$, a field defined on the Detail fill‑in. The Heading fill‑in is defined as shown in the following screen:

=>

 ‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑
 IDEAL   : RPT HEADING/FOOTING   RPT CUSTRPT  (001) TEST           SYS: DOC  DISP 

          Field Name, Literal, Function,                   Column
 Command  or Arithmetic Expression                         Wid Tab Edit Pattern 
 ‑‑‑‑‑‑   ‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑ ‑‑  ‑‑‑ ‑‑‑‑‑‑‑‑‑‑‑‑‑
 ======   ==================== T O P ===================== ==  === =============
 000300   <<BF>> LEVEL 1                                   __  ___ _____________
 000400   'Current State:'                                 __  ___ _____________
 000500   STNAMES                                          __  +02 _____________
 000600   'Outstanding Amount:'                            __  040 _____________
 000700   $TOT(CUSTOMER.OPEN$)____________________________ __  +02 _____________
 ======   ===================== B O T T O M ============== ==  === =============

When the current level 1 control break is for Texas, the footing prints as the following:

Current State:  TEXAS      Outstanding Amount:  10,911.28

You can derive values for the current page by specifying the function as all or part of the <<PF>> group. Each page footing contains the requested value for the current page.

If a function is requested on the Detail fill‑in and is included in the <<BF>> group on the Heading fill‑in, the default control break footing does not print except at the end of the report. The specifications on the Heading fill‑in print as part of the report as designated, as summary or annotated values.