In this section: |
This section provides considerations when using WebFOCUS commands with burst reports.
When the SUBTOTAL, SUB-TOTAL, SUMMARIZE, or RECOMPUTE commands are used with burst reports, the WebFOCUS Reporting Server automatically suppresses the grand total. For example, the following code might produce the Excel report, shown below, for a burst value of PRODCAT (Product Category) shown in the image below.
TABLE FILE CENTINV
SUM QTY_IN_STOCK
BY PRODCAT SUBTOTAL
BY PRODTYPE BY PRODNAME
ON TABLE PCHOLD FORMAT EXL2K FORMULA
END
The grand total for each product type is suppressed, and the quantity in stock values are totaled only by product category.
When a report with ON TABLE COLUMN-TOTAL is burst, a column total is created for each burst value. For example, the following code might produce the Excel report, shown below, for a burst value of PRODCAT (Product Category) shown in the image below.
TABLE FILE CENTINV
SUM QTY_IN_STOCK
BY PRODCAT
BY PRODTYPE SUBTOTAL BY PRODNAME
ON TABLE PCHOLD FORMAT EXL2K FORMULA
ON TABLE COLUMN-TOTAL
END
A column total is created for each product type (for example, Analog), and the quantity in stock values are totaled by product category.
WebFOCUS |