If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Blank Charts on Report opening
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 |
#2
|
|||
|
|||
On Fri, 25 Mar 2005 21:03:17 -0500, AlCamp wrote:
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 In the Report Format event for the section that the graph is placed in, i.e. Report Header: Me!OLEUnboundName.Requery -- Fred Please only reply to this newsgroup. I do not reply to personal email. |
#3
|
|||
|
|||
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 "fredg" wrote in message news On Fri, 25 Mar 2005 21:03:17 -0500, AlCamp wrote: 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 In the Report Format event for the section that the graph is placed in, i.e. Report Header: Me!OLEUnboundName.Requery -- Fred Please only reply to this newsgroup. I do not reply to personal email. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Problem Opening Report From Form | Marie | New Users | 1 | February 3rd, 2005 12:14 AM |
Odd behavior in reports with multiple charts | Tom | Setting Up & Running Reports | 0 | January 16th, 2005 02:55 AM |
report sometimes prints final blank page (except for page header) | John S. Ford, MD | Setting Up & Running Reports | 3 | December 11th, 2004 11:50 AM |
Help Printing a Report with Blank Fields | Jen | New Users | 6 | May 1st, 2004 02:32 PM |