A
Alan Z. Scharf
Hi,
1. Are there alternative ways to link an MS Graph to a parent report besides
using the Link Master/ Link Child graph properties?
2. Reason: Using the normal Master/Child methods, in some cases, the wrong
graph prints from the recordset on which the Report is based.
The report is being printed from a recordset of FundCodes, but for the graph
linked by the FundCode field, sometimes the graph prints for the Wrong
FundCode, i.e. not the current FundCode in the recordset whose data is
being printed in the main parent report.
Hence, for some reason, the Master/Child link is not working.
3. I've described my probelm in detail below, but essentially, is there
another approach I can use to link my graph to the main parent report?
Thanks very much.
Alan
Problem using Link Master/Child method:
--------------------------------------------
1. I have an Access 2003 ADP connected to SQLServer 2000.
2. My report has 3 subreports and 3 separate MS Graphs - Horizontal Bar,
Pie, and Area.
3. All subReports and Graphs are linked with MasterField, Chiled Field
properties , on field called FundCode which is in both main report query
and subreports/ grtaphs row source query.
4. Reports are printed in a loop from a recordset containing FundCode field.
Hence, report is opening and closing with printing for each FundCode record.
Problem
----------
5. About 95% of the time, everything works OK.
However, occasionally, the Horizontal Bar Chart prints data for a ***
Different
FundCode *** in the recordset, while all the other subreports and graphs on
the
same report print data for the proper current FundCode in the recordset.
The data as printed for the Different FundCode is correct for the Fund Code,
but it IS NOT what is supposed to be the linked FundCode!
*** If I didn't see this myself, I would say it was impossible!!!
There doesn't seem to be any pattern as to which FundCode is the wrong one
printed for the one problem bar graph on the report. The improper FundCode
for which data is printed could be several records away from the proper
FundCode whose data is being correctly in all the other subreports'/graphs
for a particular record.
Question
----------
1. Any idea why this couldl be happening?
2. Are there any other ways to link graph to main report other than using
the Master/Child properties, that would assure a tighter link between the
common FundCode on the main report and graph?
Alan
1. Are there alternative ways to link an MS Graph to a parent report besides
using the Link Master/ Link Child graph properties?
2. Reason: Using the normal Master/Child methods, in some cases, the wrong
graph prints from the recordset on which the Report is based.
The report is being printed from a recordset of FundCodes, but for the graph
linked by the FundCode field, sometimes the graph prints for the Wrong
FundCode, i.e. not the current FundCode in the recordset whose data is
being printed in the main parent report.
Hence, for some reason, the Master/Child link is not working.
3. I've described my probelm in detail below, but essentially, is there
another approach I can use to link my graph to the main parent report?
Thanks very much.
Alan
Problem using Link Master/Child method:
--------------------------------------------
1. I have an Access 2003 ADP connected to SQLServer 2000.
2. My report has 3 subreports and 3 separate MS Graphs - Horizontal Bar,
Pie, and Area.
3. All subReports and Graphs are linked with MasterField, Chiled Field
properties , on field called FundCode which is in both main report query
and subreports/ grtaphs row source query.
4. Reports are printed in a loop from a recordset containing FundCode field.
Hence, report is opening and closing with printing for each FundCode record.
Problem
----------
5. About 95% of the time, everything works OK.
However, occasionally, the Horizontal Bar Chart prints data for a ***
Different
FundCode *** in the recordset, while all the other subreports and graphs on
the
same report print data for the proper current FundCode in the recordset.
The data as printed for the Different FundCode is correct for the Fund Code,
but it IS NOT what is supposed to be the linked FundCode!
*** If I didn't see this myself, I would say it was impossible!!!
There doesn't seem to be any pattern as to which FundCode is the wrong one
printed for the one problem bar graph on the report. The improper FundCode
for which data is printed could be several records away from the proper
FundCode whose data is being correctly in all the other subreports'/graphs
for a particular record.
Question
----------
1. Any idea why this couldl be happening?
2. Are there any other ways to link graph to main report other than using
the Master/Child properties, that would assure a tighter link between the
common FundCode on the main report and graph?
Alan