does anyone know how to change the chart rowsource using vba withan unbound chart in a report.
I want a chart to work with multiple record sources in a multiuser environment. Had intended to build a query def for individual users with their name attached to run a passthrough into oracle. but i need to change the chart rowsource for each user.
And did the suggested approach work?
Because it gave me an error and I managed to find a post where it said that if you wanted to change the sql of a chart in a report you'd have to change the querydef instead!