Single page report showing up on 4 pages

JHARRIS133

unread,

Jul 19, 2005, 3:30:02 PM7/19/05

to

I've got a report that needs to be on a single page. The data all fits on a
single page, but then when I run the report, it shows up with the exact same
data on each of the three remaining pages, minus the header than is in the
Report Header section. My data is in the Data section (and is correct). Any
help would be greatly appreciated!

Duane Hookom

unread,

Jul 19, 2005, 4:08:50 PM7/19/05

to

Are you using subreports? If you look at your report's record source in
datasheet view, do you see multiple copies of records?

--
Duane Hookom
MS Access MVP
--

"JHARRIS133" <JHARR...@discussions.microsoft.com> wrote in message
news:06E73D02-2E28-4E00...@microsoft.com...

JHARRIS133

unread,

Jul 19, 2005, 4:59:02 PM7/19/05

to

No, there is only 1 row for each record in the datasheet view. Yes, I am
using subreports though.

Duane Hookom

unread,

Jul 19, 2005, 5:48:32 PM7/19/05

to

Apparently your main report record source has the same level of detail as
your subreport. The main report record source should not contain the same
level of detail as the subreport.

For instance, if your main report contained order information and the
subreport contained order details, you would not want the order details in
the main report's record source.

--
Duane Hookom
MS Access MVP
--

"JHARRIS133" <JHARR...@discussions.microsoft.com> wrote in message

news:4C8BE2A0-145B-441B...@microsoft.com...

JHARRIS133

unread,

Jul 20, 2005, 11:00:10 AM7/20/05

to

The report I'm working on it a bit strange. I received the database from
someone else, so I did not originally design this. The report has 3 graphs
in it, and one subreport. Each of the graphs is using the correct data that
is specified in the header, and the subreport is also using the same data.
If I remove that query that the charts are based off of from the header, the
charts will not work. Do you know of a way I could get around this
limitation?

Duane Hookom

unread,

Jul 20, 2005, 2:14:51 PM7/20/05

to

You need to define your report to us a bit more. You mention "header"
several times but we have no idea what you mean. Also, are there links to
the subreport and graphs?

--
Duane Hookom
MS Access MVP

"JHARRIS133" <JHARR...@discussions.microsoft.com> wrote in message

news:D0A93AB1-4B97-4AEB...@microsoft.com...

JHARRIS133

unread,

Jul 20, 2005, 3:21:07 PM7/20/05

to

Sorry for the confusion. In my report, the recordsource is qry1. Then
within this report are 3 embedded graphs, one has a row source based on qry2,
with the others having a row source that is a select statement. The select
statements are querying two different tables, which are not used in either
qry1 or qry2. Then, there is also a subreport within this report that has a
recordsource of qry1.

These four different pieces (the 3 graphs and 1 subreport) create this
single report. Please let me know if more clarification is needed. Thanks.

Duane Hookom

unread,

Jul 20, 2005, 4:09:27 PM7/20/05

to

Do you actually need a record source for the main report?

--
Duane Hookom
MS Access MVP

--

"JHARRIS133" <JHARR...@discussions.microsoft.com> wrote in message

news:A9038DC1-2D16-433B...@microsoft.com...

JHARRIS133

unread,

Jul 20, 2005, 4:37:02 PM7/20/05

to

No, it looks like that was unnecessary and what was causing the problems.
Thanks for the help!