Charts - Multiple Pages of same chart

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

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
--

"Art" wrote in message
...
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

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
--

"Art" wrote in message
...
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


.

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
--

"Art" wrote in message
...

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
--

"Art" wrote in message
...
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


.