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, and is displayed in Enterprise View in Administration Services.