Chart problem

[StevePZ]

I am about to throw my computer across the room. I am trying to put a chart at the bottom of my report. Okay fine, no big deal, but the chart keeps losing sinc with the main report. The main report is looking at one employee and the chart is still looking at the previous employee. I am putting the chart in the employee group footer with a forced new page after. Has anyone ever run into this problem? and how do you fix it?

Thanks,
Steve

 

[sillysod]

you need to requery the chart when info changes.


without knowing what changes and how it changes, easiest thing i can suggest is adding a button and in the click event put yourchartname.requery

 

[HockeyGuy]

Steve:

Depending on the data, I have placed a chart on a subreport (as the sole control on the report). I have then put the subreport on the main report and set the child/master property of the subreport control so that they remain in sync.

HTH

Rick

 

[StevePZ]

Rick,
Thanks for the suggestion, but I can't get it to work. When I try to add the chart to the other sub-report it shows up blank even when I view it through the subreport. Somewhere the connection is being lost.

Sorry, I realized I posted this to the Form Forum instead of the Report Forum.