Displaying the Heading in a Rollup Table

How to:

When using a rollup table generated from a tabular active report, you can either display the heading that is supplied by Active Technologies or display a custom heading that you supply in the original tabular report procedure.

Top of page
x
Syntax: How to Display the Heading in a Rollup Table

Use the following WebFOCUS StyleSheet syntax

ON TABLE SET STYLE *
TYPE=REPORT, ARDEFAULTHEAD={GENERATED|ORIGINAL},$

where:

GENERATED

In the rollup table, this setting displays the heading that is supplied by Active Technologies, whether or not a custom heading is supplied in the original tabular report procedure.

If you do not supply a custom heading in the original tabular report procedure, and you do not include the ARDEFAULTHEAD attribute in the procedure, ARDEFAULTHEAD defaults to GENERATED.

ORIGINAL

If you supply a custom heading in the original tabular report procedure, this setting displays the custom heading in the rollup table. If you do not supply a custom heading in the original tabular report procedure, this setting displays the heading supplied by Active Technologies.

If you supply a custom heading in the original tabular report procedure, but you do not include the ARDEFAULTHEAD attribute in the procedure, the rollup table automatically displays the custom heading, that is, ARDEFAULTHEAD defaults to ORIGINAL. To display the heading supplied by Active Technologies, you must specify ARDEFAULTHEAD=GENERATED.
Example: Displaying the Heading Supplied by Active Technologies

Consider the following tabular report procedure:

TABLE FILE GGSALES
SUM UNITS DOLLARS BUDDOLLARS
BY REGION
HEADING
"ABC COMPANY CONFIDENTIAL"
ON TABLE PCHOLD FORMAT FLEX
ON TABLE SET STYLE *
.
.
.
ENDSTYLE
END

In this example, the procedure contains a custom heading, ABC COMPANY CONFIDENTIAL. ARDEFAULTHEAD is not included in the WebFOCUS StyleSheet code. By default, the tabular report and the rollup table display the custom heading from the tabular report procedure, as shown in the following two images.

The tabular report is:

By default, the rollup table generated from the tabular report is:

To display the heading supplied by Active Technologies in the rollup table, you must add ARDEFAULTHEAD=GENERATED to the tabular report procedure:

TABLE FILE GGSALES
SUM UNITS DOLLARS BUDDOLLARS
BY REGION
HEADING
"ABC COMPANY CONFIDENTIAL"
ON TABLE PCHOLD FORMAT FLEX
ON TABLE SET STYLE *
TYPE=REPORT, ARDEFAULTHEAD=GENERATED,$
ENDSTYLE
END

The following is the rollup table generated from the tabular report:

WebFOCUS