This sample report has two different page layouts on the same page.
Year Profit_% Actual East West South Market ========= ========= ========= ========= Stereo -0.52% 1.91% 0.00% 0.91% Compact_Disc 32.60% 36.00% 0.00% 34.60% Audio 17.86% 20.81% 0.00% 19.60% Television 20.40% 16.57% 13.50% 17.21% VCR 30.81% 32.43% 33.70% 32.24% Camera 16.66% 21.66% 17.83% 19.07% Visual 23.16% 23.56% 22.27% 23.09% Product 21.34% 22.50% 22.27% 22.04% Sales Actual Product Qtr1 Qtr2 Qtr3 Qtr4 Year ========= ======== ======== ======== ======== New_York $18,631 $17,681 $19,923 $24,403 $80,638 Boston $15,812 $15,050 $16,716 $19,159 $66,737 Chicago $16,536 $15,599 $17,411 $21,374 $70,920 East $50,979 $48,330 $54,050 $64,936 $218,295 San_Francisco $19,761 $19,019 $20,722 $24,807 $84,309 Seattle $13,766 $13,546 $14,204 $19,034 $60,550 Denver $13,800 $13,588 $13,838 $18,232 $59,458 Los_Angeles $17,866 $17,269 $17,208 $22,635 $74,978 West $65,193 $63,422 $65,972 $84,708 $279,295 Dallas $ 9,226 $ 9,175 $ 9,481 $12,700 $40,582 Houston $ 7,690 $ 7,363 $ 7,646 $10,785 $33,484 Phoenix $ 8,157 $ 7,903 $ 8,343 $11,843 $36,246 South $25,073 $24,441 $25,470 $35,328 $110,312 Market $141,245 $136,193 $145,492 $184,972 $607,902
Use the following script to create Sample 11:
<PAGE (Year, Accounts, Scenario) <COLUMN (Market) <ICHILDREN Market <ROW(Product) <IDESCENDANTS Product Actual { DECIMAL 2 WIDTH 10 SUPBRACKETS AFTER "%" } Profit_% ! <PAGE (Accounts, Scenario, Product) Actual Sales Product <COLUMN(Year) <ICHILDREN Year <ROW(Market) { DECIMAL 0 After " " BEFORE "$" } <IDESCENDANTS Market !
In a single report, you can select multiple dimension layouts and members. To define a multiple layout report, define reports as you normally do. Separate the commands with exclamation marks as shown above. Whenever the column, row, or page dimensions change between ! output commands, new headings are automatically generated to match the new layout.
The BEFORE format command places a character in front of data values. The AFTER format command turns off the percent signs from the first report layout.
his report script, 2LAYOUTS.REP, is available in the \ARBORPATH\App\Demo\Basic directory, and is displayed in Enterprise View in Administration Services.