Suppressing the Display of Rows

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.


Top of page

Example: Suppressing the Display of a TAG Row

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

Top of page

x
Suppressing Rows With No Data

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.



Example: Suppressing Rows With No Data

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