Blank Charts on Report opening

  • Thread starter Thread starter AlCamp
  • Start date Start date
A

AlCamp

I have a report based on a RollNo (the one), and use 3 subforms to display
associated Defect data (the many).
The main report totals query uses the value from an open form to retsrict
the RollNo returned to only one.
The 3 subforms are linked (Parent/Child) by RollNo, and display all the data
with no problem.

The problem...
I have two XY Scatter charts linked to the report (Parent/Child) by RollNo,
but when I first Preview the report via the calling form, both charts come
up blank.
If I close the report and re-preview via the calling form... still the
same... both charts are blank.

But, if I go into Design mode for the report, and then preview, the charts
display perfectly!

I'm doing a Refresh of my form just before I open the report, but those
charts just don't seem to wake up.
I tried filtering my crosstab queries behind my charts by using
=Forms!frmInspectionDefects!RollNo instead of the usual Parent/Child
linking, but each graph says it can't find that object when they try to open
(the form IS open, and I have the name correct)
I'm thinking maybe the report isn't completely open as the charts come
alive, and that's why I'm getting blanks... but I've never had this problem
with other charting projects.

Don't know what else to try. Any suggestions would be appreciated.

Thanks,
Al Camp
 
I have a report based on a RollNo (the one), and use 3 subforms to display
associated Defect data (the many).
The main report totals query uses the value from an open form to retsrict
the RollNo returned to only one.
The 3 subforms are linked (Parent/Child) by RollNo, and display all the data
with no problem.

The problem...
I have two XY Scatter charts linked to the report (Parent/Child) by RollNo,
but when I first Preview the report via the calling form, both charts come
up blank.
If I close the report and re-preview via the calling form... still the
same... both charts are blank.

But, if I go into Design mode for the report, and then preview, the charts
display perfectly!

I'm doing a Refresh of my form just before I open the report, but those
charts just don't seem to wake up.
I tried filtering my crosstab queries behind my charts by using
=Forms!frmInspectionDefects!RollNo instead of the usual Parent/Child
linking, but each graph says it can't find that object when they try to open
(the form IS open, and I have the name correct)
I'm thinking maybe the report isn't completely open as the charts come
alive, and that's why I'm getting blanks... but I've never had this problem
with other charting projects.

Don't know what else to try. Any suggestions would be appreciated.

Thanks,
Al Camp
Click to expand...
In the Report Format event for the section that the graph is placed
in, i.e. Report Header:

Me!OLEUnboundName.Requery
 
Fred,
Thanks for the reply. My Graphs are Graph1 and Graph2 in the Report
Footer, so...

Private Sub ReportFooter_Format(Cancel As Integer, FormatCount As Integer)
Me!Graph1.Requery
Me!Graph2.Requery
End Sub

However, this causes an error...
"Cannot use the crosstab of a non-fixed column as a subquery. (Error 3637)"
Same thing with this error... after going into design mode and previewing
again, everything displays perfectly.

Now I'll try shooting that problem...
Thanks,
Al Camp
 
Back
Top