×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Reasons that records duplicate in reports?

Reasons that records duplicate in reports?

Reasons that records duplicate in reports?

(OP)
I use Access and Crystal to report out of a SQL server, Excel files, and Access databases, sometimes all three at once.  

In both programs I have noticed that my records will duplicate anywhere from 2-15 times in the detail section.  Select Distinct or some variation thereon only works if you stick with one data source, and sometimes not even then.

What are some possible causes of record duplication?  I think my linking is ok, but how would I know?

RE: Reasons that records duplicate in reports?

Usually caused by incorrectly joined tables.  Someone with a better knowledge of the database schema would probably need to look at your queries.

General rule of thumb is that the parent table's primary key joins to one or more fields of the child table.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible.  All it takes is a little research. (Me)
noevil
http://www.mrdenny.com

RE: Reasons that records duplicate in reports?

Maybe you have the fields in the data sources appearing to be different due to how the ODBC Drivers are looking at the different data sources.  

If you do not like my post feel free to point out your opinion or my errors.

RE: Reasons that records duplicate in reports?

I would say incorrect connection between tables. You can try to eliminate duplices by using Select Distinct or Select Distinct Row in the source of your report.

Pampers afro
Just let it go...

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close