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.