How to: |
Insert text anywhere in your FML report by typing it on a line by itself and enclosing it within double quotation marks. You can also add blank lines, designated as text, to improve the appearance of the report.
In addition, you can include data developed in your FML report in a row of free text by including the label for the data variable in the text row.
In this example, three rows of free text are inserted, one blank and two text rows:
TABLE FILE LEDGER SUM AMOUNT FOR ACCOUNT " --- CASH ACCOUNTS ---" OVER 1010 AS 'CASH ON HAND' OVER 1020 AS 'DEMAND DEPOSITS' OVER 1030 AS 'TIME DEPOSITS' OVER " " OVER " --- OTHER CURRENT ASSETS ---" OVER 1100 AS 'ACCOUNTS RECEIVABLE' OVER 1200 AS 'INVENTORY' END
The output is shown as follows.
AMOUNT ------ --- CASH ACCOUNTS --- CASH ON HAND 8,784 DEMAND DEPOSITS 4,494 TIME DEPOSITS 7,961 --- OTHER CURRENT ASSETS --- ACCOUNTS RECEIVABLE 18,829 INVENTORY 27,307
Notice that the blank row was created by enclosing a blank within double quotation marks on a separate line of the report request.
"text <label[(c)][>]"
where:
In this example, the RECAP value CURASST is suppressed by the NOPRINT command, and inserted instead as a data variable in the text row.
SET PAGE-NUM=OFF
TABLE FILE LEDGER
SUM AMOUNT FOR ACCOUNT
10$$ AS 'Cash' LABEL CA OVER
1100 AS 'Accounts Receivable' LABEL AR OVER
1200 AS 'Inventory' LABEL INV OVER
RECAP CURASST/I5C = CA + AR + INV; NOPRINT OVER
"Current Assets: <CURASST"
END
The output is shown in the following image.
AMOUNT ------ Cash 21,239 Accounts Receivable 18,829 Inventory 27,307 Current Assets: 67,375
Information Builders |