Sample 2: Handling Missing Values

This report has the same layout and member selection as Sample 1, and shows you how to use page breaks and labels for missing values.

                               Sales Actual Stereo

                          Qtr1     Qtr2     Qtr3     Qtr4
                      ======== ======== ======== ========
East                     7,839    7,933    7,673   10,044
West                    11,633   11,191   11,299   14,018
South                      N/A      N/A      N/A      N/A
  Market                19,472   19,124   18,972   24,062
 

                             Sales Actual Compact_Disc

                          Qtr1     Qtr2     Qtr3     Qtr4
                      ======== ======== ======== ========
East                    10,293    9,702    9,965   11,792
West                    14,321   14,016   14,328   17,247
South                      N/A      N/A      N/A      N/A
  Market                24,614   23,718   24,293   29,039

                                Sales Actual Audio

                          Qtr1     Qtr2     Qtr3     Qtr4
                      ======== ======== ======== ========
East                    18,132   17,635   17,638   21,836
West                    25,954   25,207   25,627   31,265
South                      N/A      N/A      N/A      N/A
  Market                44,086   42,842   43,265   53,101

Use the following script to create Sample 2:

<PAGE (Accounts, Scenario, Product)
Sales
Actual
<IDESCENDANTS Product
{ PAGEONDIMENSION Product }
{ MISSINGTEXT "N/A" }

      <COLUMN (Year)
      <CHILDREN Year

<ROW(Market)
<ICHILDREN Market
    ! 

The PAGEONDIMENSION format command creates a page break whenever a member from the specified dimension changes. Because the report selects eight Product members, the report is eight pages long.

The MISSINGTEXT format command substitutes any strings enclosed within double quotes into the #MISSING string. To suppress missing values, use the SUPMISSINGROWS command.

You can also combine format commands within one set of braces:

{ PAGEONDIMENSION Product MISSINGTEXT "N/A" } 

This report script, MISS_LBL.REP, is available in the \ARBORPATH\App\Demo\Basic directory.