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
TABLE FILE CENTINV
SUM QTY_IN_STOCK
BY PRODCAT SUBTOTAL
BY PRODTYPE BY PRODNAME
ON TABLE PCHOLD FORMAT EXL2K FORMULA
END
might produce the following Excel report for a burst value of PRODCAT (Product Category). 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
TABLE FILE CENTINV
SUM QTY_IN_STOCK
BY PRODCAT
BY PRODTYPE SUBTOTAL BY PRODNAME
ON TABLE PCHOLD FORMAT EXL2K FORMULA
ON TABLE COLUMN-TOTALEND
might produce the following Excel report for a burst value of PRODCAT (Product Category). A column total is created for each product type (for example, Analog), and the quantity in stock values are totaled by product category.
WebFOCUS |