A
Alan Z. Scharf
Hi,
Setup
------
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 the wrong
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.
*** 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?
Thank very much.
Alan
Setup
------
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 the wrong
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.
*** 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?
Thank very much.
Alan