The Detail fill‑in specifies which function executes for the field.
For example, a report is to print all of the customers in the CUSTOMER table. The report includes the total amount of accounts receivable (total OPEN$) from all customers in each state. The value is annotated and displayed at the control break.
To accomplish this, you must specify the following:
The following screen shows the Detail fill‑in for this report:
=> ‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑ IDEAL : RPT DETAIL DEFN. RPT CUSTRPT (001) TEST SYS: DOC DISP Field Name, Literal, Sort Break Function Column Function, or L A L S I T M M A H W Command Arithmetic Expression V / V K N O A I V D ID Tab Edit Pattern L D L P D T X N G G TH ‑‑‑‑‑‑ ‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑ ‑ ‑ ‑ ‑ ‑ ‑ ‑ ‑ ‑ ‑ ‑‑ ‑‑‑ ‑‑‑‑‑‑‑‑‑‑‑‑‑ ====== =========== T O P ======= = = = = = = = = = = == === ============= 000400 CUSTOMER.NAME _ _ _ _ _ _ _ _ _ U __ ___ _____________ 000500 CUSTOMER.CITY _ _ _ _ _ _ _ _ _ U __ ___ _____________ 000600 CUSTOMER.STATE _ _ 1 2 N _ _ _ _ _ __ ___ _____________ 000700 CUSTOMER.OPEN$ _ _ _ _ _ A _ _ _ U __ ___ Z,ZZZ,ZZ9.99_ ====== ========= B O T T O M === = = = = = = = = = = == === =============
The column headings are user‑defined. The following example shows the resulting details and annotated total for the states of Tennessee and Texas only.
Customer Name City Open Dollar ** STATE TN SUNSTRAND BANKS MEMPHIS 932.21 BAY‑BANK AUTOMOBILES NASHVILLE 123.15 TOTAL Open Dollar 1,055.36 ** STATE TX AFTON INDUSTRIES DALLAS 1,234.51 GULF LAND USA DALLAS 7,100.00 TEXAS LIFE & CASUALTY DALLAS 543.21 CHEMICAL MUTUAL FORT WORTH 931.72 PALMOLIVE INNS FORT WORTH 758.93 UNION TRANSPORTATION GALVESTON 0.00 SOUTHLAND STORES HOUSTON 342.91 TOTAL Open Dollar 10,911.28
You can specify the value to print on a summary line beneath the corresponding column by typing S instead of A under the appropriate function name on the Detail Fill‑in. Looking at just the states of Tennessee and Texas, this prints as the following:
Customer Name City Open Dollar ** STATE TN SUNSTRAND BANKS MEMPHIS 932.21 BAY‑BANK AUTOMOBILES NASHVILLE 123.15 TOTAL 1,055.36 ** STATE TX AFTON INDUSTRIES DALLAS 1,234.51 GULF LAND USA DALLAS 7,100.00 TEXAS LIFE & CASUALTY DALLAS 543.21 CHEMICAL MUTUAL FORT WORTH 931.72 PALMOLIVE INNS FORT WORTH 758.93 UNION TRANSPORTATION GALVESTON 0.00 SOUTHLAND STORES HOUSTON 342.91 TOTAL 10,911.28
RDF automatically computes the width of the printed field containing the total for summary and annotated values. The width is computed as the defined field length plus five. You can override this by defining the width on the Detail fill‑in.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|