Any body knows what could produce d

[bito3000]

Any body knows what could produce data duplication in the report output.... I revised the link tables I moved in all possible combinations and still get the data duplicated...4 time. What else can I do...?

 

[Dilyias]

Probably some incorrect joins (linked tables) . I Would create a new temp report with just one of the tables, test run it, then add the next table, test run it, etc.. to find out what table/join is causing the duplication. Or build a test query of the same joins you use in your report.

-Eric

 

[dgillz]

Are you using tables with a many to one relationship? If that is the case this behaviour is expected fro crystal reports.

If this is the case nd yur data is being quadrupled, in your case, use running total fields rather than sums to get your totals. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[synapsevampire]

You can select distinct records to help with this, or if you have an older version of CR, you can use a Union to select distinct (let me know if you need this).

Post your SQL from the report, that way the folks here might have a chance at analyzing the problem.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com