Graphs displaying in print preview though not printing

[Sue Compelling]

Hi

I have a report generated from a cross tab query and have added in a graph
(data sourced from a different select query). The report is grouped on
[campaign] and on print preview, happily displays all data and graphs
correctly.

However, when I print the report the graph dislay is empty though presents
as an empty rectangle.

Any clues? (I'm using ACCESS 2007)

TIA

 

[Duane Hookom]

Most of the time I read of an issue like this, the cause is code in the
report close event that closes a form that supplies a criteria to the graph.

If this isn't your issue, please provide the Row Source property of your
chart and the Link Master/Child properties.

 

[Sue Compelling]

Hi Duane

Row source: SELECT [Level_3],Sum([CountOfLevel_3]) AS [SumOfCountOfLevel_3]
FROM [CampStatVolsClosedNoSaleDet] GROUP BY [Level_3];

Link Master Fields: Campaign
Link Child Fields: Campaign
--
Sue Compelling

Most of the time I read of an issue like this, the cause is code in the
report close event that closes a form that supplies a criteria to the graph.

If this isn't your issue, please provide the Row Source property of your
chart and the Link Master/Child properties.
--
Duane Hookom
Microsoft Access MVP

Hi

I have a report generated from a cross tab query and have added in a graph
(data sourced from a different select query). The report is grouped on
[campaign] and on print preview, happily displays all data and graphs
correctly.

However, when I print the report the graph dislay is empty though presents
as an empty rectangle.

Any clues? (I'm using ACCESS 2007)

TIA

 

[Duane Hookom]

Is Campaign a field available in CampStatVolsClosedNoSaleDet?
Did you confirm there isn't a form that provides criteria that might be
closed?
Do you have user applied criteria in the reports record source or in
CampStatVolsClosedNoSaleDet?
--
Duane Hookom
Microsoft Access MVP

Hi Duane

Row source: SELECT [Level_3],Sum([CountOfLevel_3]) AS [SumOfCountOfLevel_3]
FROM [CampStatVolsClosedNoSaleDet] GROUP BY [Level_3];

Link Master Fields: Campaign
Link Child Fields: Campaign
--
Sue Compelling

Most of the time I read of an issue like this, the cause is code in the
report close event that closes a form that supplies a criteria to the graph.

If this isn't your issue, please provide the Row Source property of your
chart and the Link Master/Child properties.
--
Duane Hookom
Microsoft Access MVP

Hi

I have a report generated from a cross tab query and have added in a graph
(data sourced from a different select query). The report is grouped on
[campaign] and on print preview, happily displays all data and graphs
correctly.

However, when I print the report the graph dislay is empty though presents
as an empty rectangle.

Any clues? (I'm using ACCESS 2007)

TIA