This report builds on Sample 8: Creating Custom Headings and % Characters by adding custom page headings. By default, page dimension members are output at the top center of a report page. This section shows a representative part of the output.
Prepared by :admin The Electronics Club Page: 1 Actual Profit by Product 12/12/01 Product: Stereo Jan Feb Mar Apr May Jun New York 1.43% -10.00% -3.51% -2.22% 1.14% -6.18% Boston -0.34% -2.51% -4.44% -4.89% -7.02% -13.15% Chicago -0.65% -0.72% -2.28% -3.53% -6.33% -10.79% San Francisco 1.43% -1.87% 4.42% 2.15% -1.26% 0.66% Seattle 0.95% -5.66% 1.42% -6.82% -11.47% -12.34% Denver 3.03% -1.11% -5.88% -6.52% -5.17% -13.83% Los Angeles -1.50% -3.94% -2.86% -3.29% 3.12% -2.51% Dallas #Missing #Missing #Missing #Missing #Missing #Missing Houston #Missing #Missing #Missing #Missing #Missing #Missing Phoenix #Missing #Missing #Missing #Missing #Missing #Missing East 0.18% -4.47% -3.39% -3.41% -3.60% -9.70% West 0.98% -2.95% -0.13% -2.81% -2.62% -5.61% South #Missing #Missing #Missing #Missing #Missing #Missing Market 0.65% -3.56% -1.44% -3.06% -3.03% -7.29% Prepared by :admin The Electronics Club Page: 2 Actual Profit by Product 12/12/01 Product:Compact Disc Jan Feb Mar Apr May Jun New York 32.51% 29.95% 35.30% 32.70% 30.45% 31.73% Boston 33.42% 27.92% 33.98% 30.74% 27.45% 30.85% Chicago 34.29% 30.48% 26.33% 28.83% 28.11% 33.76% San Francisco 37.77% 35.02% 33.41% 33.23% 35.32% 37.95% Seattle 40.41% 38.33% 38.89% 37.06% 37.01% 38.29% Denver 31.93% 32.10% 34.82% 29.15% 32.71% 30.85% Los Angeles 31.65% 30.22% 30.22% 31.45% 27.06% 33.20% Dallas #Missing #Missing #Missing #Missing #Missing #Missing Houston #Missing #Missing #Missing #Missing #Missing #Missing Phoenix #Missing #Missing #Missing #Missing #Missing #Missing East 33.35% 29.50% 32.30% 30.92% 28.77% 32.09% West 35.51% 33.94% 34.21% 32.77% 33.16% 35.25% South #Missing #Missing #Missing #Missing #Missing #Missing Market 34.60% 32.10% 33.41% 32.01% 31.35% 33.97% Prepared by :admin The Electronics Club Page: 8 Actual Profit by Product 12/12/01 Product:Product Jan Feb Mar Apr May Jun New York 22.71% 21.43% 13.11% 10.54% 9.73% 13.16% Boston 24.98% 23.25% 19.95% 18.00% 17.03% 18.62% Chicago 22.01% 17.94% 18.14% 15.45% 18.70% 16.01% San Francisco 23.71% 20.60% 21.93% 20.45% 21.44% 19.98% Seattle 21.06% 21.05% 21.24% 19.00% 21.72% 15.13% Denver 21.61% 16.01% 19.79% 14.81% 20.66% 13.89% Los Angeles 17.54% 15.51% 17.03% 14.33% 17.59% 16.09% Dallas 15.67% 16.50% 15.32% 13.93% 20.36% 15.49% Houston 20.01% 20.29% 20.62% 15.87% 23.60% 12.38% Phoenix 20.01% 16.12% 17.18% 16.50% 21.39% 15.22% East 23.19% 20.84% 16.89% 14.42% 14.94% 15.78% West 21.02% 18.35% 19.99% 17.26% 20.30% 16.61% South 18.39% 17.53% 17.59% 15.36% 21.66% 14.46% Market 21.37% 19.09% 18.46% 15.92% 18.67% 15.93%
Use the following script to create Sample 9:
<PAGE (Accounts, Scenario, Product) <IDESCENDANTS Product <SORTLEVEL { PAGEONDIMENSION Product } { STARTHEADING TEXT 1 "Prepared by:" 14 "*USERNAME" C "The Electronics Club" 65 "*PAGESTRING" SUPPAGEHEADING UNDERLINECHAR " " TEXT C "Actual Profit by Product" 65 "*DATE" TEXT 1 "Product:" 10 "*PAGEHDR 3" SKIP ENDHEADING } Profit_% Actual <COLUMN (Year) Jan Feb Mar Apr May Jun <ROW(Market) { DECIMAL 2 AFTER "%" SUPBRACKETS UNDERSCORECHAR " " } { INDENTGEN 1 } <IDESCENDANTS Market !
The SUPPAGEHEADING format command suppresses the default page headings from output.
The *PAGEHDR command customizes the location of page member labels. The Sample 9 script uses page heading number 3, Product because this is the third page dimension.
You may have also noticed that member names do not have underscores. The UNDERSCORECHAR format command blanks out underscores.
Another difference is the underlining of column headings. The UNDERLINECHAR format command causes the underlining to character to change to the character in quotes.
The report rows are also sorted according to their levels in the database outline. Sort commands, such as SORTLEVEL, do not affect individual members selected in reports. Instead, these commands work in conjunction with member selection commands.
Note: | You can use only one sort command in a report. |
Sample 9 reverses the indentation of levels from previous reports. The INDENTGEN command indents members to the specified number of characters.
This report script, HEADING2.REP, is available in the \ARBORPATH\App\Demo\Basic directory, and is displayed in Enterprise View in Administration Services.