chart/graph in report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that the details are great, however, I do some calculations
in the report itself. Is there a way to get the chart/graph to be made from
the results of the calculations?
 
Mandy:

Yes, you can do this. It requires a bit of Visual Basic programming to do
so however. Essentially, what drives a Graph, is its Data Sheet. In
Access when you set a graph's record source to a query, what Access does is
fill the Data Sheet of the Graph object when the Graph is run by the report.

You can add an unbound graph object to your report and via Visual Basic,
fill its data table to produce the graph.

If you stop by our web site and look in the Code and Design Tips area, the
current tip is titled: " Changing the Record Source for a Graph in a Report
"

This shows how to dynamically use a recordset to fill the data sheet of a
Graph object. What you would need to do is to simply place the values from
your report into the Graph object's cells; using the syntax used in the tip
it would work like this:

objDS.Cells(1, 1) = Me!YourReportControl.Value
objDS.Cells(1, 2) = Me!YourReportControl2.Value

etc.

Hope this helps
 
Back
Top