Hi,

I have a compound report with three reports embedded in it.One of them is a GRAPH in PNG format. I created an output option variable and using it in all the reports.HTML format works great. But when I tried to export it to excel/pdf/ppt its not working. I am getting -

MIME-Version: 1.0 X-Document-Type: Workbook Content-Type: multipart/related; boundary="====Boundary====" --====Boundary==== Content-Location: file:///C:/HOLD.XHT Content-Transfer-Encoding: 8bit Content-Type: text/html; charset="us-ascii" --====Boundary==== Content-Location: file:///C:/IBIT0001.xht Content-Transfer-Encoding: 8bit Content-Type: text/html; charset="us-ascii" -- FOR THE SECOND REPORT WHICH IS A GRAPH

--====Boundary==== Content-Location: file:///C:/IBIT0002.xht Content-Transfer-Encoding: 8bit Content-Type: text/html; charset="us-ascii" - FOR THE FIRST REPORT

--====Boundary====-- FOR THE THIRD REPORT

So, I removed the chart (for testing purpose) and tried with just the 2 reports. It works but for PDF and PPT format, its breaking the columns. The
columns which don't fit in the page are being moved to next page. I want all the columns to be on one page.

&OUTPUT could be HTML/EXL2K/PDF/PPT

ON TABLE PCHOLD FORMAT &OUTPUT OPEN -- for the first report
ON TABLE PCHOLD FORMAT &OUTPUT CLOSE-- for the second report


Please advise.

Thank you.
KK

You've only got so much real estate when working with printed output. Try setting SQUEEZE=ON, using a smaller font, using WIDTH=to force wrapping in columns, move BY fields into subheadings, decreasing spaces between columns. Hard to give a specific solution without more detail.
Also, are you aware that to get graphics into PDF reports, you first need to create the image, hold it (FORMAT PNG, JPG, or whatever) then insert the image into a second report? This technique is described in the documentation.

Darin,

Can you provide me with an example (code) for exporting graphs.

Thank you.
KK

Here's a quick example - I've taken a lot of the stylesheet code out.

 GRAPH FILE CLAIMS
SUM TOTL_INCR AS ''
ACROSS RENEWAL_YR AS 'Renewal Year'
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D ON
ON GRAPH SET VZERO OFF
ON GRAPH SET GRID ON
ON GRAPH SET VAXIS 500
ON GRAPH SET HAXIS 1600
ON GRAPH SET GRMERGE ON
ON GRAPH SET GRAPHSTYLE *
ENDSTYLE
ON GRAPH HOLD AS INCUR FORMAT JPEG
END
-RUN
TABLE FILE CLAIMS
HEADING
"Trend by Renewal Period for Claims Filed and Incurred Costs"
"<POL_NAM - &POLNBR.EVAL &LOCHEAD.EVAL &DEPTHEAD.EVAL "
"Run on &DATEtrMDYY "
" "
SUM CLMCNT NOPRINT
WHERE READLIMIT EQ 1
FOOTING BOTTOM
"Page <TABPAGENO "
ON TABLE SET HTMLCSS ON
ON TABLE SET PAGE-NUM OFF
ON TABLE SET STYLE *
     UNITS=IN,
     PAGESIZE='Letter',
     LEFTMARGIN  =0.50000,
     RIGHTMARGIN =0.50000,
     TOPMARGIN   =0.250000,
     BOTTOMMARGIN=0.250000,
     ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='TIMES NEW ROMAN',
     SIZE= 10 ,
     COLOR='BLACK',
     BACKCOLOR='NONE',
     STYLE=NORMAL,
$
TYPE=HEADING,
     SIZE=12,
     STYLE=BOLD,
     JUSTIFY=CENTER,
$
TYPE=HEADING, IMAGE= INCUR.jpg ,  SIZE=(10.5 3.500),  POSITION=( 0.2500 3.500 ),$
TYPE=FOOTING, SIZE=7, JUSTIFY=CENTER,$
ENDSTYLE
ON TABLE PCHOLD FORMAT &OUTPUT
END 

Darin,

Thanks a lot. It worked!!. There is one problem though,

I am getting the graph and data in PDF and PPT formats but the data is not properly aligned.
I don't need the data in these formats.

In excel format I am getting the data but not the graph. Any ideas ?

And the graph is not working in a compound report. It probably needs to be on its own.

KK.

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

Graph works fine for me in a compound report. I'll have to look at the Excel stuff I don't use that very much