Report Errors - Charts

  • Thread starter Thread starter David
  • Start date Start date
D

David

I have a fairly complicated report which pulls in
information from various other reports, including some
charts. The problem is that sometimes the charts pick up
the wrong data. This happens about 10% of the time and is
totally unpredictable. The charts are based on a query
which filters data from a large database based on a
project number. For some reason sometimes one or another
of the charts will pick up the wrong project (the rest of
the data and charts on the report will be ok).

Any ideas why and how I can fix? This happens more often
when I do a screen preview of the report, but also
sometimes when I print the report.
 
I think I found the reference you are referring to but it
didn't work. Did I do something wrong? By the way - I am
using Access97.

I inserted the following code in the On Print box (note
that I have 3 graphs)
On Error Resume Next
Dim objGraph1 As Object
Dim objGraph2 As Object
Dim objGraph3 As Object
Set objGraph1 = Me![Rptn_GM Chart].Object
Set objGraph2 = Me![Rptn_PF Chart].Object
Set objGraph3 = Me![Rptn_Schedule Chart].Object
objGraph1.Refresh
objGraph2.Refresh
objGraph3.Refresh
DoEvents
Set objGraph1 = Nothing
Set objGraph2 = Nothing
Set objGraph3 = Nothing
 
Are you actually pulling "information from various other reports" into your
report? This might be an issue since I can't imagine how this would happen
unless you are using subreports.

--
Duane Hookom
MS Access MVP


David said:
I think I found the reference you are referring to but it
didn't work. Did I do something wrong? By the way - I am
using Access97.

I inserted the following code in the On Print box (note
that I have 3 graphs)
On Error Resume Next
Dim objGraph1 As Object
Dim objGraph2 As Object
Dim objGraph3 As Object
Set objGraph1 = Me![Rptn_GM Chart].Object
Set objGraph2 = Me![Rptn_PF Chart].Object
Set objGraph3 = Me![Rptn_Schedule Chart].Object
objGraph1.Refresh
objGraph2.Refresh
objGraph3.Refresh
DoEvents
Set objGraph1 = Nothing
Set objGraph2 = Nothing
Set objGraph3 = Nothing
-----Original Message-----
Check out ACG's information on reporting tips at
http://ourworld.compuserve.com/homepages/attac- cg/acgsoft.htm

--
Duane Hookom
MS Access MVP
--




.
Click to expand...
Click to expand...
 
Yes, these are subreports. I input the project number
into a Form. The various subreports and main report
reference the project number from the Form. I don't have
any problem with tabular information that is also brought
in this way, only with the graphs.

By the way - I realized that I am picking up the Sample
graph, so I went back and added the extra line
objGraph.Application.Update, but I am still having the
same problem. I also have included the same code in the
individual subreports as well as in the main report.
Still no luck.

Any other ideas?
-----Original Message-----
Are you actually pulling "information from various other reports" into your
report? This might be an issue since I can't imagine how this would happen
unless you are using subreports.

--
Duane Hookom
MS Access MVP


David said:
I think I found the reference you are referring to but it
didn't work. Did I do something wrong? By the way - I am
using Access97.

I inserted the following code in the On Print box (note
that I have 3 graphs)
On Error Resume Next
Dim objGraph1 As Object
Dim objGraph2 As Object
Dim objGraph3 As Object
Set objGraph1 = Me![Rptn_GM Chart].Object
Set objGraph2 = Me![Rptn_PF Chart].Object
Set objGraph3 = Me![Rptn_Schedule Chart].Object
objGraph1.Refresh
objGraph2.Refresh
objGraph3.Refresh
DoEvents
Set objGraph1 = Nothing
Set objGraph2 = Nothing
Set objGraph3 = Nothing
-----Original Message-----
Check out ACG's information on reporting tips at
http://ourworld.compuserve.com/homepages/attac- cg/acgsoft.htm

--
Duane Hookom
MS Access MVP
--

I have a fairly complicated report which pulls in
information from various other reports, including some
charts. The problem is that sometimes the charts
Click to expand...
pick
up
the wrong data. This happens about 10% of the time
Click to expand...
and
is
totally unpredictable. The charts are based on a query
which filters data from a large database based on a
project number. For some reason sometimes one or another
of the charts will pick up the wrong project (the
Click to expand...
rest
of
the data and charts on the report will be ok).

Any ideas why and how I can fix? This happens more often
when I do a screen preview of the report, but also
sometimes when I print the report.


.
Click to expand...
Click to expand...


.
Click to expand...
 
There are times when you might need to create smaller, indexed temporary
tables for report record sources to clear up this type of issue. I can't be
more helpfull since I don't have enough information on how and where all the
complicated information is coming from and going to.

--
Duane Hookom
MS Access MVP
--

David said:
Yes, these are subreports. I input the project number
into a Form. The various subreports and main report
reference the project number from the Form. I don't have
any problem with tabular information that is also brought
in this way, only with the graphs.

By the way - I realized that I am picking up the Sample
graph, so I went back and added the extra line
objGraph.Application.Update, but I am still having the
same problem. I also have included the same code in the
individual subreports as well as in the main report.
Still no luck.

Any other ideas?
-----Original Message-----
Are you actually pulling "information from various other reports" into your
report? This might be an issue since I can't imagine how this would happen
unless you are using subreports.

--
Duane Hookom
MS Access MVP


David said:
I think I found the reference you are referring to but it
didn't work. Did I do something wrong? By the way - I am
using Access97.

I inserted the following code in the On Print box (note
that I have 3 graphs)
On Error Resume Next
Dim objGraph1 As Object
Dim objGraph2 As Object
Dim objGraph3 As Object
Set objGraph1 = Me![Rptn_GM Chart].Object
Set objGraph2 = Me![Rptn_PF Chart].Object
Set objGraph3 = Me![Rptn_Schedule Chart].Object
objGraph1.Refresh
objGraph2.Refresh
objGraph3.Refresh
DoEvents
Set objGraph1 = Nothing
Set objGraph2 = Nothing
Set objGraph3 = Nothing

-----Original Message-----
Check out ACG's information on reporting tips at
http://ourworld.compuserve.com/homepages/attac-
cg/acgsoft.htm

--
Duane Hookom
MS Access MVP
--

I have a fairly complicated report which pulls in
information from various other reports, including some
charts. The problem is that sometimes the charts pick
up
the wrong data. This happens about 10% of the time and
is
totally unpredictable. The charts are based on a query
which filters data from a large database based on a
project number. For some reason sometimes one or
another
of the charts will pick up the wrong project (the rest
of
the data and charts on the report will be ok).

Any ideas why and how I can fix? This happens more
often
when I do a screen preview of the report, but also
sometimes when I print the report.


.
Click to expand...


.
Click to expand...
Click to expand...
 
I failed to mention I am using Access 97. My reading
indicates this is a known problem with Access 97 and I
cannot find any reference to a fix.

I have thought about making temporary tables, but this
would complicate things somewhat.

-----Original Message-----
There are times when you might need to create smaller, indexed temporary
tables for report record sources to clear up this type of issue. I can't be
more helpfull since I don't have enough information on how and where all the
complicated information is coming from and going to.

--
Duane Hookom
MS Access MVP
--

David said:
Yes, these are subreports. I input the project number
into a Form. The various subreports and main report
reference the project number from the Form. I don't have
any problem with tabular information that is also brought
in this way, only with the graphs.

By the way - I realized that I am picking up the Sample
graph, so I went back and added the extra line
objGraph.Application.Update, but I am still having the
same problem. I also have included the same code in the
individual subreports as well as in the main report.
Still no luck.

Any other ideas?
-----Original Message-----
Are you actually pulling "information from various
Click to expand...
other
reports" into your
report? This might be an issue since I can't imagine
Click to expand...
how
this would happen
unless you are using subreports.

--
Duane Hookom
MS Access MVP


I think I found the reference you are referring to
Click to expand...
but
it
didn't work. Did I do something wrong? By the way -
Click to expand...
I
am
using Access97.

I inserted the following code in the On Print box (note
that I have 3 graphs)
On Error Resume Next
Dim objGraph1 As Object
Dim objGraph2 As Object
Dim objGraph3 As Object
Set objGraph1 = Me![Rptn_GM Chart].Object
Set objGraph2 = Me![Rptn_PF Chart].Object
Set objGraph3 = Me![Rptn_Schedule Chart].Object
objGraph1.Refresh
objGraph2.Refresh
objGraph3.Refresh
DoEvents
Set objGraph1 = Nothing
Set objGraph2 = Nothing
Set objGraph3 = Nothing

-----Original Message-----
Check out ACG's information on reporting tips at
http://ourworld.compuserve.com/homepages/attac-
cg/acgsoft.htm

--
Duane Hookom
MS Access MVP
--

I have a fairly complicated report which pulls in
information from various other reports, including some
charts. The problem is that sometimes the charts pick
up
the wrong data. This happens about 10% of the
Click to expand...
time
and
is
totally unpredictable. The charts are based on a query
which filters data from a large database based on a
project number. For some reason sometimes one or
another
of the charts will pick up the wrong project (the rest
of
the data and charts on the report will be ok).

Any ideas why and how I can fix? This happens more
often
when I do a screen preview of the report, but also
sometimes when I print the report.


.



.
Click to expand...
Click to expand...


.
Click to expand...
 
I'm about to give up. I tried creating temporary tables
for the charts to run against (with just the one active
project), but still getting charts against the sample
data. The sample data appears to be set based on whatever
data is in the table when I design the chart. I can re-
set it by doing a print preview from within the design
mode for the chart.

-----Original Message-----
There are times when you might need to create smaller, indexed temporary
tables for report record sources to clear up this type of issue. I can't be
more helpfull since I don't have enough information on how and where all the
complicated information is coming from and going to.

--
Duane Hookom
MS Access MVP
--

David said:
Yes, these are subreports. I input the project number
into a Form. The various subreports and main report
reference the project number from the Form. I don't have
any problem with tabular information that is also brought
in this way, only with the graphs.

By the way - I realized that I am picking up the Sample
graph, so I went back and added the extra line
objGraph.Application.Update, but I am still having the
same problem. I also have included the same code in the
individual subreports as well as in the main report.
Still no luck.

Any other ideas?
-----Original Message-----
Are you actually pulling "information from various
Click to expand...
other
reports" into your
report? This might be an issue since I can't imagine
Click to expand...
how
this would happen
unless you are using subreports.

--
Duane Hookom
MS Access MVP


I think I found the reference you are referring to
Click to expand...
but
it
didn't work. Did I do something wrong? By the way -
Click to expand...
I
am
using Access97.

I inserted the following code in the On Print box (note
that I have 3 graphs)
On Error Resume Next
Dim objGraph1 As Object
Dim objGraph2 As Object
Dim objGraph3 As Object
Set objGraph1 = Me![Rptn_GM Chart].Object
Set objGraph2 = Me![Rptn_PF Chart].Object
Set objGraph3 = Me![Rptn_Schedule Chart].Object
objGraph1.Refresh
objGraph2.Refresh
objGraph3.Refresh
DoEvents
Set objGraph1 = Nothing
Set objGraph2 = Nothing
Set objGraph3 = Nothing

-----Original Message-----
Check out ACG's information on reporting tips at
http://ourworld.compuserve.com/homepages/attac-
cg/acgsoft.htm

--
Duane Hookom
MS Access MVP
--

I have a fairly complicated report which pulls in
information from various other reports, including some
charts. The problem is that sometimes the charts pick
up
the wrong data. This happens about 10% of the
Click to expand...
time
and
is
totally unpredictable. The charts are based on a query
which filters data from a large database based on a
project number. For some reason sometimes one or
another
of the charts will pick up the wrong project (the rest
of
the data and charts on the report will be ok).

Any ideas why and how I can fix? This happens more
often
when I do a screen preview of the report, but also
sometimes when I print the report.


.



.
Click to expand...
Click to expand...


.
Click to expand...
 
OK - Problem Solved. Instead of using subreports I simply
inserted the graphs directly into the main report. Then I
was able to use the code to run "On Print" to get it to
run correctly. Thanks for your help and staying with me.

The code I used (for the 3 graphs) is as follows:

On Error Resume Next
Dim objGraph1 As Object
Dim objGraph2 As Object
Dim objGraph3 As Object
Set objGraph1 = Me!GMChart.Object
Set objGraph2 = Me!PFChart.Object
Set objGraph3 = Me!SchChart.Object
objGraph1.Refresh
objGraph2.Refresh
objGraph3.Refresh
objGraph1.Application.Update
objGraph2.Application.Update
objGraph3.Application.Update
DoEvents
Set objGraph1 = Nothing
Set objGraph2 = Nothing
Set objGraph3 = Nothing

-----Original Message-----
There are times when you might need to create smaller, indexed temporary
tables for report record sources to clear up this type of issue. I can't be
more helpfull since I don't have enough information on how and where all the
complicated information is coming from and going to.

--
Duane Hookom
MS Access MVP
--

David said:
Yes, these are subreports. I input the project number
into a Form. The various subreports and main report
reference the project number from the Form. I don't have
any problem with tabular information that is also brought
in this way, only with the graphs.

By the way - I realized that I am picking up the Sample
graph, so I went back and added the extra line
objGraph.Application.Update, but I am still having the
same problem. I also have included the same code in the
individual subreports as well as in the main report.
Still no luck.

Any other ideas?
-----Original Message-----
Are you actually pulling "information from various
Click to expand...
other
reports" into your
report? This might be an issue since I can't imagine
Click to expand...
how
this would happen
unless you are using subreports.

--
Duane Hookom
MS Access MVP


I think I found the reference you are referring to
Click to expand...
but
it
didn't work. Did I do something wrong? By the way -
Click to expand...
I
am
using Access97.

I inserted the following code in the On Print box (note
that I have 3 graphs)
On Error Resume Next
Dim objGraph1 As Object
Dim objGraph2 As Object
Dim objGraph3 As Object
Set objGraph1 = Me![Rptn_GM Chart].Object
Set objGraph2 = Me![Rptn_PF Chart].Object
Set objGraph3 = Me![Rptn_Schedule Chart].Object
objGraph1.Refresh
objGraph2.Refresh
objGraph3.Refresh
DoEvents
Set objGraph1 = Nothing
Set objGraph2 = Nothing
Set objGraph3 = Nothing

-----Original Message-----
Check out ACG's information on reporting tips at
http://ourworld.compuserve.com/homepages/attac-
cg/acgsoft.htm

--
Duane Hookom
MS Access MVP
--

I have a fairly complicated report which pulls in
information from various other reports, including some
charts. The problem is that sometimes the charts pick
up
the wrong data. This happens about 10% of the
Click to expand...
time
and
is
totally unpredictable. The charts are based on a query
which filters data from a large database based on a
project number. For some reason sometimes one or
another
of the charts will pick up the wrong project (the rest
of
the data and charts on the report will be ok).

Any ideas why and how I can fix? This happens more
often
when I do a screen preview of the report, but also
sometimes when I print the report.


.



.
Click to expand...
Click to expand...


.
Click to expand...
 
Back
Top