Duplicated records 1

[RealityCheque]

I'm using Crystal Reports 9 to report on 3 tables, 2 of which are connected to the first via a one-many relationship, ie

Orders <- Detail -> Assignment

When only one of the secondary tables is in the report, everything works fine - but as soon as I add the third table, I get a copy of each order for every single assignment.

The purpose of the report (in case this helps) is to summarise each job for our customers - the order table holds information on all the orders placed both internal and external, and the assignment table holds, well, assignments. What I'm trying to do is total all the external order prices and display the latest assignment - all of which works seperately and only fails when I try to display them both in the same report

Simon

"I do not have to forgive my enemies. I have had them all shot."
- Ramon Maria Narvaez

 

[WinterDragon]

If you are using An Accounting Program such as Peachtree, See Below....

Peachtree does double-entry accounting, so you are probably getting both the debit and credit entries of the transaction.

To suppress the duplicate information add the following to your selection criteria.

{JrnlRow.RowType} = 0

 

[RealityCheque]

Thankfully this info has been nowhere near our accounting program by the time it gets here! But that's info worth noting for future reference, cheers

Simon

"I do not have to forgive my enemies. I have had them all shot."
- Ramon Maria Narvaez

 

[lbass]

I'm not clear on the relationship between the fields in the tables, but you can either use running totals so that you can eliminate duplicates from your calculations, or, if assignments are used for display, you might add that table in a subreport so that it doesn't create duplication.

-LB

 

[RealityCheque]

All the tables are linked together via a field called 'CallID', but I think I'm going to have to take your second suggestion and use a subreport.

Thanks!

Simon

"I do not have to forgive my enemies. I have had them all shot."
- Ramon Maria Narvaez