Focal Point
[Solved] Is it possible to create a graph from subtotals

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5737042126

June 13, 2012, 03:53 PM
ELockett
[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
END

This 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

June 18, 2012, 08:25 AM
ELockett
Works like a charm! Thanks so much Smiler


App Studio 8.2.03 Windows all formats