Chart based on data from report

[Lucas]

I'm looking for an answer how to make a chart in the report, but this chart
has to take data from cells in the report.
I have a report that collects data from queries and make a some mathematical
operations on them. At the end of the report I make a summary of the data
(also data which comes from mathematical operations made in this report). The
problem is I don't know how to make chart based on results of this operations.

 

[Duane Hookom]

I would place the values in a temp table and graph them. There are solutions
that set the datasheet values of a chart with code like:
http://support.microsoft.com/kb/182131

 

[Lucas]

OK, I will try this. Could you send me some information about getting data
from the report to table, because I'm trying to find a way to do this but
can't. The problem is that my report generates a lot of data, for example:
summary for 1 up to 10 groups. For each group there is a summary and I' have
to create a chart for each summary so I need to gather 10 x 21 (because I
have 21 boxes that make operations for each summary, so there is 210 values
that I have to collect in loop) values and place them to table to create data
from it.

„Duane Hookom†pisze:

 

[Duane Hookom]

I would not use a report to create a table. I would use queries and/or code
as necessary. You haven't provided any details regarding your
tables/fields/requirements/graphs/etc so it is near impossible to assist.

If we don't know where you are and where you want to go, we can't get you
there.