This sample report contains data for Actual Sales. Each report page shows a different Product. The report lists products on the same page until the maximum page length is reached. To place each Product on a separate page, you must use the PAGEONDIMENSION format command, as shown in Sample 2: Handling Missing Values.
Because none of the cities in South sell Stereo or Compact_Disc, the data values indicate #MISSING. You can represent missing values by suppressing the row or substituting a replacement text string, such as N/A. See Sample 2: Handling Missing Values for an example of substituting 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 #Missing #Missing #Missing #Missing 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 #Missing #Missing #Missing #Missing 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 #Missing #Missing #Missing #Missing Market 44,086 42,842 43,265 53,101
Use the following script to create Sample 1:
<PAGE (Accounts, Scenario, Product) Sales Actual <IDESCENDANTS Audio <COLUMN (Year) <CHILDREN Year <ROW(Market) <ICHILDREN Market !
The ! report output command is required to generate the report.
Because the IDESCENDANTS selection command is used for Audio, the report selects all three members. Only a single member is selected from the other page dimensions, Sales and Actual. As a result, the script creates three report pages. They display as one long report page unless you use the PAGEONDIMENSION format command, as shown in Sample 2: Handling Missing Values.
This report script, ACTSALES.REP, is available in the \ARBORPATH\App\Demo\Basic directory, and is displayed in Enterprise View in Administration Services.