[Solved] Is it possible to create a graph from subtotals
I want to create a bar chart based on the subtotals that I receive when I run this report. How would I do that? Here's an example of the type of report, using the car file.
TABLE FILE CAR PRINT CAR.BODY.DEALER_COST CAR.BODY.DEALER_COST CAR.BODY.RETAIL_COST BY LOWEST CAR.BODY.BODYTYPE
ON CAR.BODY.BODYTYPE SUBTOTAL AS '*TOTAL' ON TABLE SET PAGE-NUM NOLEAD ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT HTML ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * INCLUDE = endeflt, $ ENDSTYLE ENDThis message has been edited. Last edited by: Kathleen Butler,
App Studio 8.2.03 Windows all formats
June 13, 2012, 04:04 PM
FrankDutch
sure
rather basic, if you change PRINT TO SUM you get only the totals per bodytype
these can be used in a graph
GRAPH FILE CAR SUM DEALER_COST RETAIL_COST BY BODYTYPE etc
Frank
prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7