I didn't know how to move a post from one Forum to another so here is what was posted on the other Forum.
This isn't what I need. This give 2 bar graphs side by side. I need one graph with 2 bars, one for each year, next to each other, like the Excel example shows. http://i35.tinypic.com/2a7zbbq.jpg Excel did it very easily, so I would think WebFOCUS could. I'm missing something.
Thanks,
Rick Man Silver Member Posted August 19, 2008 04:50 PM How can I create a graph in WebFOCUS like the one I was able to create in Excel; i.e. where the years are side by side in ONE graph not in two separate graphs. Thanks
whoa...where is centurysales? its not in ibisamp. buy me a vowel?
answered my own question...its in ibidemo in devstu . aha.
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
September 04, 2008, 09:07 AM
GinnyJakes
Susannah,
Since you are on Unix like I am, you can upload the directory to your backend Unix box. There is a program to reload the databases. A lot of the tutorials use centurysales and the file has lots of data in it. Great for testing.
Thanks Kerry. Thanks Ginny. I don't have any data in that file. I opened a case with IBI, #42422997, and this is what they said:
Take this code:
GRAPH FILE FINANCE SUM AMOUNT AS 'AMOUNT' ACROSS YEAR AS 'YEAR' BY ACCOUNT AS 'ACCOUNT' HEADING "FINANCE GRAPH1" ON GRAPH SET LOOKGRAPH BAR ON GRAPH SET GRMERGE ON ON GRAPH PCHOLD FORMAT GIF ON GRAPH SET GRAPHSTYLE * setLegendPosition(2); setFontName(getLegendText(),"ARIAL"); ENDSTYLE END
And flip flop the ACROSS and BY fields:
GRAPH FILE FINANCE SUM AMOUNT AS 'Amount' ACROSS ACCOUNT AS 'Account' BY YEAR AS 'Year' HEADING "FINANCE GRAPH2" ON GRAPH SET LOOKGRAPH BAR ON GRAPH SET GRMERGE ON ON GRAPH PCHOLD FORMAT GIF ON GRAPH SET GRAPHSTYLE * setLegendPosition(2); setFontName(getLegendText(),"ARIAL"); ENDSTYLE END
It works.
Reporting Server 7.6.10 Dev. Studio 7.6.8 Windows NT Excel, HTML, PDF
September 04, 2008, 02:15 PM
GinnyJakes
Which is exactly what I did if you compare my two sets of code.