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

 

[Sue Compelling]

Hi Duane

In answer to your questions:

1) yes it is
2) yes I did - no criteria comes from a form
3) no user applied criteria either

Thanks for your efforts so far ....
--
Sue Compelling

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

 

[Duane Hookom]

Where is the crosstab query used?
Can you share the code that is used to open the report?
What is the record source of the report (SQL view)?
Where on the report (which section) is the graph?

--
Duane Hookom
Microsoft Access MVP

Hi Duane

In answer to your questions:

1) yes it is
2) yes I did - no criteria comes from a form
3) no user applied criteria either

Thanks for your efforts so far ....
--
Sue Compelling

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

 

[Sue Compelling]

Hi Duane

'twas about to go through answering all your questions and thought I better
try the print option again - and loe and behold - great pie graphs in
technocolour.

Thanks anyway for your quick replies.

Cheers

Sue
--
Sue Compelling

Where is the crosstab query used?
Can you share the code that is used to open the report?
What is the record source of the report (SQL view)?
Where on the report (which section) is the graph?

--
Duane Hookom
Microsoft Access MVP

Hi Duane

In answer to your questions:

1) yes it is
2) yes I did - no criteria comes from a form
3) no user applied criteria either

Thanks for your efforts so far ....
--
Sue Compelling

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