Focal Point
[CLOSED] Graph and tabular reports

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

May 26, 2011, 06:33 AM
Jan1
[CLOSED] Graph and tabular reports
Hi ,

I need to create a set of 5 graphs in excel report.

Below is the link of the two graphs that need to be created in excel and to be placed side by side .

Links :

http://i55.tinypic.com/2uylnxt.jpg

http://i56.tinypic.com/348k66d.jpg

Can someone help with creating this . Iam quite new to graphs .

Thanks!

This message has been edited. Last edited by: Kerry,


WebFOCUS 7.6.9
Windows
Excel, HTML, PDF
May 26, 2011, 06:47 AM
FrankDutch
do you want to create the graphs in excel?
I think you should go to an excel forum to ask this.
But if you want to create these graphs in Webfocus it can be done.
In that case I wonder why you need to output it in Excel.
In PDF or HTML this is possible. You save the graphs to SVG format and in the compound painter you can place the graphs where you like to.




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

May 26, 2011, 07:33 AM
Jan1
Sorry , my mistake.

The graphs have to be created in webfocus and in Excel format . if its not possible in excel ,its fine in HTML .

In the sample graphs that i sent , iam abel to create the graph with the X-xis and Y-axis plots . But iam not sure how to get the data just below the graph i.e

jan feb
2% 4%

should this be created as a separate tabular report and merged below the graph . If so , how do we do this ?

thanks!


WebFOCUS 7.6.9
Windows
Excel, HTML, PDF
May 31, 2011, 07:47 AM
Cyril Joy
I think you can create a graph and a report and show the report below the graph in HTML. It is difficult to have the alignment exactly as in the example, but you cna get almost the same structure.

If you use excel template, I guess you will be able to get the same output.


Regards,
Cyril Joy.

WF Production 8008 on Linux.
May 31, 2011, 08:59 AM
atturhari
quote:
Originally posted by Jan1:
should this be created as a separate tabular report and merged below the graph . If so , how do we do this ?

thanks!


Yes. You should create them seperately and merge them in Composer tool. Since the positions are going to be static, you can get the same outptut.


WF 7.7.02 on Windows 7
Teradata
HTML,PDF,EXCEL,AHTML