Master - Child Graph Mystery

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

Guest

Hello

Fortunately I stumbled upon a solution to my frustration, but wondered if
anyone could tell me why this happed -

I have a graph on a report picking up data from a table
(tblPortfolioReturns) -
ClientIDFOF
NRL_Date
Return

In the recordsource of my report, I also have the field ClientIDFOF and was
using that as the master/child link between my report and the graph. The
field was residing in the group header section of my report, but when it was
there, my graph would not draw.

Just through fiddling, I tried moving the ClientIDFOF textbox into the
detail section of the report and the graph now works faultlessly.

Is there some reason behind this that I have missed?

Thanks
Tarryn
 
Your link/child property refers to the current record's values, if you where
putting the chart in the heading, the current record in the table may not
have a value corresponding to the chart, when you put it on the detail, then
the record had something to link to in the chart rowsource, I hope this makes
sense,
 
Back
Top