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:
Is a required left caret to bracket the label.
Is the explicit or implicit row label. (In a RECAP, the calculated value functions as the label.)
Is an optional cell identifier that indicates the column number of the cell. However, this identifier is required whenever there is more than one column in the report. If you use it, enclose it in parentheses.
Is an optional right caret that can be used to make the positioning clearer.
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 |