Charts - Multiple Pages of same chart

[Art]

I create a stacked bar chart based upon a calendar year
for different departments within my organization. The
chart is correct except that I get multiple pages of the
same thing. I only want the first page and nort the other
duplicate pages. I am using Access 2002 and the chart is
based upon a Select Query that only has 4 fields (Date,
Total, Category, Department). Without using the PrintOut
Function in a macro or withou having the toolbar to be
visable so a File, Print, Page 1 operation can be done;
how can I get only the first page to print?

If there is any ideas as to why I get duplicate pages of
the same graph that would be even better but I will accept
any suggestion as to have it programed to only Print Page
1. The printing of the chart is controlled by a Form
which has the Control Button for Print Preview.

Thank You

 

[Duane Hookom]

It sounds like you have a high level of detail in your report's record
source and a chart control in a high level of detail. Sometimes it isn't
necessary to even have a record source for the report since the chart
records come from its Row Source property.

 

[Art]

here is my Row Source.

TRANSFORM Sum([Sum Of Total Of Time]) AS [SumOfSum Of
Total Of Time] SELECT (Format([Date],"MMM")) FROM [qry YTD
Legal Graph] GROUP BY (Year([Date])*12 + Month([Date])-
1),(Format([Date],"MMM")) PIVOT [Category];

 

[Duane Hookom]

I don't think your chart's row source is the issue. Check the Record Source
of your report. If you only expect to see a single graph then you should
probably either have only one record in the report's record source or not
have any record source.

--
Duane Hookom
MS Access MVP
--

here is my Row Source.

TRANSFORM Sum([Sum Of Total Of Time]) AS [SumOfSum Of
Total Of Time] SELECT (Format([Date],"MMM")) FROM [qry YTD
Legal Graph] GROUP BY (Year([Date])*12 + Month([Date])-
1),(Format([Date],"MMM")) PIVOT [Category];

-----Original Message-----
It sounds like you have a high level of detail in your report's record
source and a chart control in a high level of detail. Sometimes it isn't
necessary to even have a record source for the report since the chart
records come from its Row Source property.

--
Duane Hookom
MS Access MVP
--




.

 

[MartinKilliner]

Many thanks from me as well for providing this answer. I have been battling for ages trying to understand why I had multiple copies of the same chart in my report. I deleted the record source from the report itself and now it's fixed.

Thanks