Sample 7: Using Aliases
This report outputs members in the middle of a page and uses aliases or alternate names. The default row member indentation is turned off.
Stereo Market
Qtr4 Year
Actual Budget Actual Budget
======== ======== ======== ========
24,062 24,900 Sales 81,630 83,650
13,937 14,442 COGS 47,654 48,517
-------- -------- -------- --------
10,125 10,458 Margin 33,976 35,133
1,438 1,600 Marketing 4,933 5,465
7,110 6,840 Payroll 28,440 27,360
-200 0 Misc. -143 0
-------- -------- -------- --------
8,348 8,440 Total_Expenses 33,230 32,825
1,777 2,018 Profit 746 2,308
======== ======== ======== ========
7.39 8.10 Profit_% 0.91 2.76
42.08 42.00 Margin_% 41.62 42.00
Compact_Disc Market
Qtr4 Period
Actual Budget Actual Budget
======== ======== ======== ========
29,039 29,250 Sales 101,664 100,300
10,830 11,115 COGS 38,120 38,114
-------- -------- -------- --------
18,209 18,135 Margin 63,544 62,186
1,669 1,780 Marketing 6,067 5,975
5,721 5,415 Payroll 22,200 21,660
-226 0 Misc. 97 0
-------- -------- -------- --------
7,164 7,195 Total_Expenses 28,364 27,635
11,045 10,940 Profit 35,180 34,551
======== ======== ======== ========
38.04 37.40 Profit_% 34.60 34.45
62.71 62.00 Margin_% 62.50 62.00
Use the following script to create Sample 7:
<PAGE (Product, Market)
{ PAGEONDIMENSION Product }
{ PAGEONDIMENSION Market }
<IDESCENDANTS Product
{ DECIMAL 0 }
<SYM
<COLUMN (Year, Scenario)
Qtr4 Year
Actual Budget
<ROW(Accounts)
{ SUPBRACKETS OUTALTNAMES NOINDENTGEN ORDER 1,2,0,3,4 }
Sales Cost_of_Goods_Sold
{ UDATA "-" }
Margin
{ SKIP }
Marketing Payroll Miscellaneous
{ UDATA "-" }
Total_Expenses
{ SKIP }
Profit
{ UDATA DECIMAL 2 }
Profit_%
Margin_%
!
The SYM command forces the report to output symmetric column groups. The default is to display two columns-one for Qtr4 Actual and one for Year Budget. Because the report calls for Actual and Budget under both Qtr4 and Year, the SYM command is required. Alternatively, repeat the Actual and Budget names under Qtr4 and Year.
The OUTALTNAMES format command causes the report to use aliases or alternate names instead of member names.
The NOINDENTGEN format command causes row members to not be indented. By default, members are indented two spaces for each level.
The ORDER command moves specified output columns to new locations. The row name is considered column 0.
The FIXCOLUMNS format command restricts the number of output columns. Reports often require both ORDER and FIXCOLUMNS. You can use ORDER to remove unwanted columns, and FIXCOLUMNS to stop these columns from displaying after the report columns.
This report script, MIDDLE.REP
, is available in the \
ARBORPATH
\App\Demo\Basic
directory.