mark wrote:
I've got an 83-page report which contains an Microsoft Graph 8 Chart,
...
Can anyone suggest:
(1) A faster query that yields the same graph? or
(2) A faster alternative to the Graph 8 component?
I've tried the MS Graph 5 component with no improvement
Thanks!
Mark
If you're interested in Adobe Reader readable pdf output directly from
Access take a look at:
http://www.oakland.edu/~fortune/SampleHistogram.pdf
and
http://www.oakland.edu/~fortune/Histogram.zip
for an example of creating graphical output. I haven't gotten around
to solving the 'Rebuild' problem yet (byte count is probably just a
little off) but Reader displays and prints everything nicely. Be sure
to close the Reader file before trying to create another with the same
name as the one that's open. Forms I've built have created thousands of
pdf documents using this technique but use at your own risk. In the
future I'll try to use other pdf readers to test the file created so
that it's more compliant. It's written in A97 so let me know if you or
anyone else have trouble converting to a different version of Access.
Partly because I'm a little unorthodox I've always used code whenever a
crosstab query could be used; so I can't give you any advice about
speeding up your query other than that I agree with the other poster's
comments.
James A. Fortune