[CLOSED] Can Accordion HTML report Display Grand Column Total in WF7.7.03?

For WF 8 the accordion HTML report can display Column Total row with commands
ON TABLE SET EXPANDBYROW ON
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE PCHOLD FORMAT HTML

However, the WF 7.7.03 has bug, it can’t display the grand column total. I need to deliver a report with the grand total for each column, but we are not ready for WF 8 upgrade. Is there a workaround way to display Grand total row?

In the following sample, I need a grand row which show DEALER_COST and SALES of all COUNTRIES combined. thanks.

  
TABLE FILE CAR
SUM 
     CAR.BODY.DEALER_COST
     CAR.BODY.SALES
BY  LOWEST CAR.ORIGIN.COUNTRY
BY  LOWEST CAR.COMP.CAR
ON TABLE SET PAGE-NUM NOLEAD 
ON TABLE SET EXPANDBYROW ON 
ON TABLE SUMMARIZE CAR.BODY.DEALER_COST CAR.BODY.SALES AS 'TOTAL'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
ENDSTYLE
END

This message has been edited. Last edited by: <Kathryn Henning>,

WebFOCUS 8.2.01 AppStudio
HTML, PDF, Excel

Posts: 61 | Registered: March 12, 2008

MartinY

Virtuoso

posted

Hide Post

I haven't been able to placed the Total at the end due to the nature of BY EXPANDBYROW, but this may answer your need:

TABLE FILE CAR
SUM DEALER_COST
    SALES
BY TOTAL COMPUTE ID/A6 = 'TOTAL';
BY COUNTRY
BY CAR
ON TABLE HOLD AS HLDDET FORMAT FOCUS
END
-RUN

TABLE FILE HLDDET
SUM DEALER_COST
    SALES
BY ID AS ''
BY COUNTRY
BY CAR
ON TABLE SET PAGE-NUM NOLEAD 
ON TABLE SET EXPANDBYROW ON 
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
ENDSTYLE
END
-RUN

WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007

Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013

Please Wait. Your request is being processed...