Embed a copy of an MS Graph chart into a report.

[jjmclell]

Hi there,

I currently have a form with an embedded MS Graph chart. The chart's row source query changes based on selections the user makes in a couple of combo boxes also on the form, hence causing the chart to change and allowing the user to look at different statistics. What I would like to do is allow the user to embed a snapshot of the chart into a report but I'm finding out that this is easier said than done. Does anyone have any ideas how I could do this?

Much appreciated,

jjmclell

 

[MazeWorX]

base the report on the same query as the form with the graph in the report

your thoughts?

HTH << MaZeWorX >> Remember amateurs built the ark - professionals built the Titanic [flush]

 

[jjmclell]

That's kind of the way I'm trying to go. The only thing is, I want the user to be able to insert as many snapshots of as many instances of the graph into the report as they want. I've built a table where the rowsource query of any particular instance of the graph is written when the user hits an "Add to Report" button. My main problem has been programmatically setting up OLE object frames in the report to hold MSGraph charts. I think I've figured it out though...I found a list of actions for OLE objects and I think I can just set the object frames' classes to [bold]MSGraph.Chart.8[/bold] and then set the rowsource queries to the values I stored in my table.

Long story short, I have one chart object in a form and I want to create multiple chart objects in a report that all have different rowsources.

jjmclell