How do I fix the repeating data in my report?

I created a report and added 20 other reports to it. The report (see attached image) repeates the data over and over again.

How do I fix this?
REPEAT-REPORT.png
cssc1Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PatHartmanCommented:
Your main report is bound to a detail table.  Given what I see, it should not be bound at all.  If it does need to be bound, then you need to change the query to return only a single record for a group.  Then all the subreports would be linked to the main report using the master/child properties.

I really cannot envision a design where this structure would be logical.  Occasionally we have "shadow" tables but they are reserved for history.  In a relational database, all rows would be in the same table and you would use queries to select sets if you wanted to use only part of the data at a time.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jeffrey CoachmanMIS LiasonCommented:
I created a report and added 20 other reports to it.

I would consider redesigning this report...
Like Pat, I can't see a need for a report with 20 sub reports....(that contain repeating data)

In any event, you cannot "Hide Duplicates" across reports.

Perhaps you could take a moment to tell us abut our data, (post a sample database) and explain the ultimate need here...
Perhaps there is a simpler approach...

JeffCoachman
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.