Print Page | Close Window

duplicate records

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19789
Printed Date: 03 Apr 2025 at 5:26pm


Topic: duplicate records
Posted By: kader
Subject: duplicate records
Date Posted: 21 Jul 2013 at 12:23am
I have 3 Table - 1. Sales line 2 Sales header 3. Purchase Header.
I would like to list all sales line data with some of the other 2 table field

I linked with sales line and sales header with a common field. In the third table I don't have any common field for all three but I have common field 2 and 3. When I link this 2 and 3 some records are duplicating. How to avoid this. please help. when I remove the third table data from the report its work fine. Please help


Replies:
Posted By: manjucrystal
Date Posted: 21 Jul 2013 at 8:35pm
Hi,
 
Try with subreport for third table related data.

Posted By: CircleD
Date Posted: 22 Jul 2013 at 1:01am
Have you tried to format the fields and check the box "Suppress if duplicated"?


Print Page | Close Window