Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

duplicate records

Status
Not open for further replies.

GRECONCG

Technical User
Joined
Oct 8, 2009
Messages
31
Location
US
Hi I have a report that shows the invoice id and the sale but it is duplicating both of these records. I am guessing it is a linking issue but not sure how to fix it, any ideas? i was thinking of surpressing the duplicate but that wouldn't work in the sale amount unless it could match the sale with the invoice id. The tables causing this are my invoice and order header tables. I've played with the links but I can't get it to stop duplicating.
 
Group. Suppress detail lines, and sort in the order you want. Show details in the group footer, which should be the last.

[yinyang] Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP [yinyang]
 
I recently wrote an article that might help you understand this issue:


Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top