PAGEHEADING

Displays the page heading before the next data-output row.

Otherwise, a new page heading occurs only if the page or column members change, a page is generated (for example, page length is exceeded or a NEWPAGE command is issued), or a page header has not been done for this page and the first output row on the page is ready to print.

If PAGEHEADING is specified between the STARTHEADING and ENDHEADING commands, however, the page heading is displayed with the heading and not immediately. This command also permanently nullifies the effect of a previously issued SUPPAGEHEADING command.

The page heading is the default heading, which contains the current page members.

Syntax

{ PAGEHEADING }

Notes

The TEXT and SUPPRESSHEADING command can be used to customize page heading text and placement.
By default, page and column headers (together called the HEADING) are turned on. This means they are displayed prior to the first actual output row in a report, and are reset to display again whenever:
1. A new page is generated.
2. Any member in the page or column dimensions changes.
3. A specific COLHEADING, PAGEHEADING, or IMMHEADING dictates a new heading. Once they are reset to display, they are output just prior to the new non-suppressed output row.
IMMHEADING produces a new page and column heading immediately, without waiting for the next non-suppressed output line.

Example

The following report script is designed for the Demo Basic cube, available in the gallery. The PAGEHEADING command inserts the page heading members in the report for a second time.

<PAGE (Market, Accounts, Scenario)
Chicago Sales Actual
      <COLUMN (Year) 
      <ICHILDREN Year
<ROW (Product)
Television
VCR
{ SKIP PAGEHEADING SKIP }
Compact_Disc
Stereo
     !

This example produces the following report:

                             Chicago Sales Actual 

                     Qtr1     Qtr2     Qtr3     Qtr4     Year 
                 ======== ======== ======== ======== ======== 

Television          4,410    4,001    4,934    6,261   19,606 
VCR                 3,879    3,579    4,276    4,877   16,611 


                             Chicago Sales Actual 

Compact_Disc        3,150    3,021    3,032    3,974   13,177 
Stereo              2,591    2,476    2,567    3,035   10,669