Embedding Excel Chart Into Report
Posted: Fri Feb 02, 2007 1:38 pm
Hi__I need to do some elaborate charts that exceed the graphing ability of Infinity and plan to use Excel 2003/2007 for the required chart(s). I would like to incorporate these charts into the actual R&R report at runtime. ____Using the runtime my plan is to export the (Report 1) summarized data from R&R directly into Excel for the required graphs. Report 2 would need to embed the graph(s) built in Excel using data provided from Report 1.____Can R&R interact with OLE? If yes do you have some examples. If no, do you have a suggestion as to how to proceed?__Thanks in advance.__Rick__