Duplicate records in report

K

keebin85_p

After I add in the subreport for my main report, I found that the tota
of records have increased and there are some duplicate record appear i
my report.
May I know why such occurence happen
 
D

Duane Hookom

This is usually because you have included the same level of detail in both
the main report and subreport.
 
M

Marshall Barton

keebin85_p said:
After I add in the subreport for my main report, I found that the total
of records have increased and there are some duplicate record appear in
my report.
Click to expand...


Where are the duplicate records? Are they in the subreport,
the main report, both?

If the subreport is appearing multiple times, it's usually
because the main report's record source query includes the
same table that hte subreport is based on. Try opening the
main report's query directly from the database or query
design window and see if you can spot the extra date
records. this should provide some clues to where they're
ccoming from.
 
K

keebin85_p

The duplicate records come from the main report.
Can I display more data for a field on a page without using subreport.
Example, I wan2 display more item name for the field ItemName.
How is it?
 
M

Marshall Barton

If the duplicate records are in the main report, they will
still be duplicated if you remove the subreport. But you
said they only appear when you include the subreport.
Sounds like there's a lot more going on than you've
explained so far.

Did you analyze the main report's query for duplicated data?

Please go back and determine where each copy of the
"duplicated" data appears in the main report and subreport.

We really need more detailed information if we're going to
figure out what's not working the way you want. The least
you can provide is a Copy/Paste of the two report's record
source query. It would also help if you posted an example
of how the report looks with an explanation of what data is
in the main report and what's in the subreport.

Your latest follow on question is way too vague for me to
have any idea about what you want. Maybe I can understand
it if you provided the information I requested above.
 
Top