Inserting Rows of Free Text

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.

Example: Inserting Free Text

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.

Syntax: How to Insert Data Variables in Text Rows

"text <label[(c)][>]"

where:

<

Is a required left caret to bracket the label.

label

Is the explicit or implicit row label. (In a RECAP, the calculated value functions as the label.)

c

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.

Example: Inserting a Data Variable in a Text Row

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