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.
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.