Is there a posibility in WebFOCUS to display the values of the actual row as a graph with the graph as a cell in the actual row?
Means:
Country Car DC RC Graph
England Jaguar 18.621 22.369 displaying DC and RC for Jaguar as bar graph
Jensen 14.940 17.850 displaying DC and RC for Jensen as bar graph
Triumph 4.292 5.100 displaying DC and RC for Triumph as bar graph
This message has been edited. Last edited by: Kerry,
WebFOCUS 7.6, 7.7 Windows, All Output formats
September 20, 2011, 09:06 AM
AlexU
Turn on visualization for both fields by right clicking on each field and selecting "visualize"
this is a good idea, but i don't need the bars behind the numbers but both bars (the one for Dealer Cost and the one for Retail Cost) in one graph as a cell in the column following on the right side of Retail Cost.
WebFOCUS 7.6, 7.7 Windows, All Output formats
September 21, 2011, 08:55 AM
PBrightwell
If your output is in HTML, you could use I-FRAMES and put your report in the left frame and your graph in the right frame.
Pat WF 7.6.8, AIX, AS400, NT AS400 FOCUS, AIX FOCUS, Oracle, DB2, JDE, Lotus Notes
September 21, 2011, 10:28 AM
<FreSte>
You could do something like this (HTML-only )
TABLE FILE CAR
SUM
DEALER_COST
RETAIL_COST
COMPUTE XTOT/D12.2 = DEALER_COST+RETAIL_COST; AS ''
BY COUNTRY
BY CAR
ON TABLE SET STYLE *
TYPE=REPORT, UNITS=POINTS, GRID=OFF,$
GRAPHTYPE=DATA,CLASS=HIDE, COLUMN=XTOT,GRAPHLENGTH=150,GRAPHCOLOR=SILVER,$
ENDSTYLE
ON TABLE SET HTMLCSS ON
ON TABLE HOLD FORMAT HTMTABLE
END
-RUN
-HTMLFORM BEGIN
<html>
<style>
.hide {
display : none;
}
</style>
<body>
!IBI.FIL.HOLD;
</body>
</html>
-HTMLFORM END
September 22, 2011, 04:03 AM
MichaelBalle
I tried the above version and got it with more than one bar. But it's also not the solution. We are looking for a report with data columns and one column containing a bar graph you can create in EXCEL. I can't append a file with the blueprint here (its an EXCEL file).
WebFOCUS 7.6, 7.7 Windows, All Output formats
September 22, 2011, 03:20 PM
<FreSte>
Can't you make a screenprint of what you need, put that somewhere on the web and create an url pointing to that image ??