Reports repeating information several times

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

Guest

I have been developing a database for our organization. i have set up a
report with calculated fields including; DCounts, Comparisons between
DCounts, Totals, etc. The problem is although I am getting correct
information, it is being repeated several times over several pages. I have
set the hide duplicates property on all of the text boxes.
 
Cassi said:
I have been developing a database for our organization. i have set up a
report with calculated fields including; DCounts, Comparisons between
DCounts, Totals, etc. The problem is although I am getting correct
information, it is being repeated several times over several pages. I have
set the hide duplicates property on all of the text boxes.
Click to expand...

The repetitions are probably coming from the records in the
report's record source table/query. Examine the data set
that the report is processing to see if you can see how to
get rid of the extra records. If the report is doing
everything with calculations, maybe the report should be
unbound??
 
The record source for this report is one table and four queries. there
should be no duplication from the tables because the report is all calculated
fields and labels. I am not sure I know how to make the report unbound.
Most of my textboxes are unbound.
 
Cassi said:
The record source for this report is one table and four queries. there
should be no duplication from the tables because the report is all calculated
fields and labels. I am not sure I know how to make the report unbound.
Most of my textboxes are unbound.
Click to expand...


Try opening the record source query from the query design or
database window and check the query's dataset carefully.
 
Back
Top