Dynamic Charts in Reports (1 Viewer)

[norm]

I've tried simply changing the embedded charts rowsource at run-time but get one of two errors: 1) cannot change rowsource after printing has begun. 2) something like cannot find object (when i try to change the property before opening the report)

Then I tried creating an XL workbook on the fly so that I could create multiple worksheets/charts... seems too complicated for what I want to do.

Last, I tried binding a chart to a query with one [parameter] thinking i could pass parameters to the querydef before opening the report. No luck.

Any suggestions would be appreciated.

 

[norm]

I just worked something out. Doesn't seem like the best solution yet so i'd still love ideas. I'm concerned about temporary objects now in my project. I think i'll need to compact often now. Any ideas other than:

dbs.CreateQueryDef QueryName, QuerySQL

And then on report_close:

dbs.QueryDefs.delete qdf.Name