Faster alternative to Microsoft Graph 5.0 Chart ??

[mark]

I've got an 83-page report which contains an Microsoft Graph 8 Chart,
but the report takes FOREVER to format, probably because the row source
is a bit complex:

TRANSFORM Sum(qryCallsSummarizedByArbitraryYear.CallCount) AS
SumOfCallCount SELECT qryCallsSummarizedByArbitraryYear.DateByYear FROM
qryCallsSummarizedByArbitraryYear GROUP BY
qryCallsSummarizedByArbitraryYear.DateByYear PIVOT
qryCallsSummarizedByArbitraryYear.[Property Code];

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

[parris...@gmail.com]

Access will evaluate the query for each chart that needs to be produced
-- even if the query is the same for each chart. If your query is
complex this can lead to very long rendering times, which you've
clearly experienced. One workaround I've had success with is to output
query results to a temporary table, then use that temporary table as
the recordsource for the report. A 20-page report now renders in 10
seconds instead of 2 minutes.

Obviously your use of temporary tables would have to be carefully
controlled in a multiuser environment.

[jimfo...@compumarc.com]

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