Turns on automatic display of the column header, and sets it to be output prior to display of the next non-suppressed output data row.
Syntax
{ COLHEADING }
Notes
The purpose of delaying the header output is to ensure that when no data follows a heading (due to suppression with a SUPMISSING or at the end of a report, for instance, a meaningless header is not generated.
IMMHEADING produces a new page and column heading immediately, without waiting for the next non-suppressed output line.
COLHEADING can be specified between the STARTHEADING and ENDHEADING commands to position the heading relative to other outputs defined in the custom heading.
When COLHEADING is used, the column members are displayed at the time the heading is generated, rather than immediately. Thus, if this command was issued at the start of the report script, it would still generate column headings only as part of the regular heading, and not as the first item on the page.
COLHEADING also displays column headings after they have been suppressed with either a SUPCOLHEADING, SUPHEADING, or SUPALL command.
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:
A new page is generated.
Any member in the page or column dimensions changes.
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.
Example
The command COLHEADING displays the column heading members for a second time in the following report after displaying a blank line with the SKIP command.
<PAGE (Market, Accounts, Scenario) Chicago Sales Actual <COLUMN (Year) <ICHILDREN Year <ROW (Product) <ICHILDREN Audio { SKIP COLHEADING } <ICHILDREN Visual !
This example produces the following report:
Chicago Sales Actual Qtr1 Qtr2 Qtr3 Qtr4 Year ======= ====== ====== ====== ======= Stereo 2,591 2,476 2,567 3,035 10,669 Compact_Disc 3,150 3,021 3,032 3,974 13,177 Audio 5,741 5,497 5,599 7,009 23,846 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 Camera 2,506 2,522 2,602 3,227 10,857 Visual 10,795 10,102 11,812 14,365 47,074
See Also