Reasons that records duplicate in reports?

[SusanStoHelit]

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?

 

[mrdenny]

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)

http://www.mrdenny.com

 

[ceh4702]

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.

 

[Pampers]

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
Just let it go...