Single page report showing up on 4 pages

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Are you using subreports? If you look at your report's record source in
datasheet view, do you see multiple copies of records?
 
No, there is only 1 row for each record in the datasheet view. Yes, I am
using subreports though.
 
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.
 
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?
 
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?
 
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.
 
No, it looks like that was unnecessary and what was causing the problems.
Thanks for the help!
 
Back
Top