MS Graph in a report

P

Peter Nikolov

I am trying to show a distribution graph for a table containing the
following numeric fields:

[Test], [Value], [Count]

I want to build a report showing a graph for every [Test], containing the
sum of [Count] for each [Value] for this [Test].

I have grouped the data first by [Test], then by [Value] and have [Count]
shown as sum.

I have embedded a MS Graph in the [Test] footer on the report. Everything
looks fine, but sometimes the report has mistaken graphs - not for the
current record [Test] but for another which is random, but also present on
the current report...

It is very strange but seems like MS Access doesn't always transfer the
correct set of data to MS Graph when building the report... When using a
form to show the similar things on screen, everything is fine.

Can someone help?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top