In this section: |
You may sometimes wish to retrieve data in a TAG row solely for use in a calculation, without displaying the row in a report. To suppress the display of a tag row, add the word NOPRINT to the row declaration, as in a TABLE request.
You may also wish to suppress the display of a TAG row if no data is found for the values. See Suppressing Rows With No Data.
In addition, you can suppress the display of RECAP rows by adding the word NOPRINT to the RECAP command, following the semicolon. This technique is useful to suppress the display of an intermediate RECAP value, which is intended for use as input to other calculations.
This example uses the value of COST in its computation, but does not display COST as a row in the report.
DEFINE FILE REGION
AMOUNT/I5C=E_ACTUAL;
END
TABLE FILE REGION
SUM AMOUNT FOR ACCOUNT
3000 AS 'SALES' LABEL SLS OVER
3100 AS 'COST' LABEL COST NOPRINT OVER
RECAP PROFIT/I5C = SLS - COST; OVER
" " OVER
RECAP ROS/F6.2 = 100*PROFIT/SLS;
AS 'RETURN ON SALES'
END
The output is shown in the following image.
AMOUNT ------ SALES 6,000 PROFIT 1,350 RETURN ON SALES 22.50
The text for a tag row is displayed even if no data is found in the file for the tag values, with a period (.) representing the missing data. You can override this convention by adding the phrase WHEN EXISTS to the definition of a TAG row. This makes displaying a row dependent upon the existence of data for the tag. This feature is useful, for example, when the same model is applied to different divisions in a company.
The CENTSYSF data source has detail-level financial data. Accounts with no children are populated, but those with children are not. The following request suppresses the display of accounts that are not populated:
SET FORMULTIPLE=ON JOIN SYS_ACCOUNT IN CENTGL TO ALL SYS_ACCOUNT IN CENTSYSF TABLE FILE CENTGL SUM NAT_AMOUNT/D10.0 NAT_YTDAMT/D10.0 FOR GL_ACCOUNT 3100 WITH CHILDREN ALL AS CAPTION WHEN EXISTS IF PERIOD EQ '2002/03' END
The output is shown in the following example.
Month YTD Actual Actual ------ ------ TV/Radio 1,049,146. 2,954,342. Print Media 244,589. 721,448. Internet Advertising 9,542. 29,578. Promotional Expenses 53,719. 151,732. Joint Marketing 97,135. 289,799. Bonuses/Commissions 100,188. 304,199.
Information Builders |