Print many charts in A2K report

[Guest]

is it possible to to have say 3 or 4 charts with 3 or 4
data sources/queries and print them on a single Access
report?

TIA johnb

 

[SA]

Sure. However, you may run into a few timing problems with numerous charts
on a page (i.e. charts may not refresh with current data very well.) You
can take a look at our web in the Code and Design tips area for the current
tip on how to force chart refresh to manage that issue.

 

[fredg]

is it possible to to have say 3 or 4 charts with 3 or 4
data sources/queries and print them on a single Access
report?

TIA johnb

Sure,
Each graph is it's own OLEUnbound object with it's own Row Source.

I would suggest you add a line of code to the section of the report
each graph is in to refresh it:
Me!OLEUnbound15.Refresh
Me!OLEUnbound16.Refresh
etc.
otherwise you might get timing problems.