Sample 11: Placing Two-Page Layouts on the Same Page

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.