All,

Having a problem with the below code. It’s producing the expected output in PDF but not in excel. In excel the graph is not show up. Why?

-* File SartSummaryProp.fex
SQL SQLMSS EX IRF_DETAIL1.DBO.BrokerSummary_Prop 'aon';
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS SMART_SUMMARY_PROP_HOLD FORMAT ALPHA
END


-*FILEDEF PP DISK C:\temp\PP.gif
-*FILEDEF PP DISK C:\IBI\WEBFOCUS\IBI_HTML\PP.GIF
SET GRAPHSERVURL=http://STSRV1/ibi_apps/IBIGraphServlet
GRAPH FILE SMART_SUMMARY_PROP_HOLD
-* CurrM2Count CurrM1Premium CurrM1Count CurrentPremium CurrentCount
SUM SMART_SU.CurrentPremium AS '2006' SMART_SU.CurrM1Premium AS '2005'
SMART_SU.CurrM2Premium AS '2004'
ACROSS SMART_SU.BrokerCity
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH HOLD AS PP FORMAT GIF
setGraphType(55);

END

-*DEFINE FILE SMART_SUMMARY_PROP_HOLD
-*IMG/A60 = '';
-*ENDIMG/A6 = '';
-*END


SET COMPOUND=CLOSE
TABLE FILE SMART_SUMMARY_PROP_HOLD
SUM CurrentPremium AS '2006' CurrM1Premium AS '2005' CurrM2Premium AS '2004'
BY BrokerCity
ON TABLE SET STYLE *
TYPE=DATA, BACKCOLOR=( BY=B2 'SILVER' 'WHITE' ), $
TYPE=REPORT, IMAGE=PP.GIF, POSITION=(4 6), SIZE=(3 3.5), $
ENDSTYLE

ON TABLE PCHOLD FORMAT EXL2K
END

Hi rc,

Has this issue been resolved on your site?

I took a quick review of your code, and just wondering, what if you remove the "-*" from this line:

-*IMG/A60 = 'C:\myimage.gif';

will that give your any different output? This may be a bit trivial, but should be worth of a try.

Cheers,

Kerry

quote:

TYPE=REPORT, IMAGE=PP.GIF, POSITION=(4 6), SIZE=(3 3.5), $

it is the syntax, i belive, rr.
this syntax :'type=report,image= 'is for pdf;
excel puts images in cells as explicit references, just as though there were data items; so you code for them as tho they were data items.
you were on the right track with your define, if your image was a long char string with an image tag sourcing your pp.gif in the agent.
then your report has to sum or print that field called img. the image will be pinned to its cell , that's how we have it working in our shop; it can get more complicated than that, but just change your thinking from pdf thinking to excel thinking.
and when you post code, remember to either surround it in code tags or turn your code tags on; and do edit your profile so we can see what version/platform you on, would you?

The main thing to remember with images is that for HTML and EXCEL the image must be available via a URL as it is included as an external reference, but for a PDF the image must be available within the APP path as it is included in the PDF data stream.

T