Focal Point
Integrating Report and Graph in a PDF

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

March 28, 2008, 04:31 AM
prash.cp
Integrating Report and Graph in a PDF
I have a concern, with PDF reports.
The report and graph are in same fex,
Requirement is to display the 1 report and 4 graphs in the same page.

i have tried using compound reports but alas it is not working.

please advise

thanks


WF 7.1.4
Windows
Excel, Html, PDF



March 28, 2008, 05:08 AM
focuzsambit
Well, store report as Hold file and graphs as images(format GIF).

Then print all in compound (ON TABLE PCHOLD FORMAT PDF OPEN NOBREAK/NOBREAK/CLOSE.
).
For report its direct print and for graphs give some dummy prints including images in style sheet (IMAGE=GTEST.GIF, POSITION=(1 4.2))

It will work that way...


WF Server: 7.1.4 on Z/OS and Linux, ReportCaster
Data: DB2, DB2/UDB, Adabas, SQL Server, Oracle Output: HTML,PDF,Excel2K
WF Client: Servlet, CGI
March 28, 2008, 05:28 AM
FrankDutch
I would prefer saving the graph as SVG.

this gives a better quality.

How to create a compound report can be found in the manual, although it is said there you can mix pdf, html and excel I would recommend to not doing it that way.

Do you have the PDF layout painter?




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

March 28, 2008, 05:36 AM
prash.cp
I tried it out that way but it is throwing up a blank PDF rather than a report

------------------------------------------------

quote:
Originally posted by focuzsambit:
Well, store report as Hold file and graphs as images(format GIF).

Then print all in compound (ON TABLE PCHOLD FORMAT PDF OPEN NOBREAK/NOBREAK/CLOSE.
).
For report its direct print and for graphs give some dummy prints including images in style sheet (IMAGE=GTEST.GIF, POSITION=(1 4.2))

It will work that way...



WF 7.1.4
Windows
Excel, Html, PDF



March 28, 2008, 05:44 AM
FrankDutch
Prash

If you post your code we might be able to see what is wrong.




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

March 28, 2008, 08:35 AM
mgrackin
Try this as an example:

GRAPH FILE CAR
SUM SALES
ACROSS COUNTRY
ON GRAPH HOLD AS 'SALES' FORMAT SVG
END
-RUN
GRAPH FILE CAR
SUM RCOST
ACROSS COUNTRY
ON GRAPH HOLD AS 'RCOST' FORMAT SVG
END
-RUN
GRAPH FILE CAR
SUM DCOST
ACROSS COUNTRY
ON GRAPH HOLD AS 'DCOST' FORMAT SVG
END
-RUN
GRAPH FILE CAR
SUM MPG
ACROSS COUNTRY
ON GRAPH HOLD AS 'MPG' FORMAT SVG
END
-RUN
TABLE FILE CAR
SUM SALES RCOST DCOST MPG
BY COUNTRY
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=REPORT, IMAGE=SALES.SVG, POSITION=(0.50 2.0), SIZE=(4.0 3.0),$
TYPE=REPORT, IMAGE=RCOST.SVG, POSITION=(4.50 2.0), SIZE=(4.0 3.0),$
TYPE=REPORT, IMAGE=DCOST.SVG, POSITION=(0.50 5.0), SIZE=(4.0 3.0),$
TYPE=REPORT, IMAGE=MPG.SVG, POSITION=(4.50 5.0), SIZE=(4.0 3.0),$
ENDSTYLE
END


Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011