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.