duplicate data in report

[fresholga]

I am using Seagate Crystal Report. The report includes many sub-reports. One of the subreports displays a set of data TWICE, although the data base shows the data to be there only once.
What causes this problem, and how do I fix it?
Thanks,

 

[Madawc]

One possibility is that the data is linked to something else that does occur twice, and you are referencing that 'something else' in your subreport detail lines.

As a work-round, you can suppress duplicates by testing
field = Previous(field)

Madawc Williams
East Anglia, Great Britain

 

[synapsevampire]

The SQL in the subreport might cause this.

If the rows are truly duplicates, try going into the subreport and select Database->Select Distinct Records

More likely they are NOT duplicates, and it's an issue with some join(s).

If it's SQL related, generic text based posts won't help anyone, post technical information:

Crystal version
Database used
Connectivity used
the SQL generated (database->Show SQL Query)
Example data
Expected output

-k