Skip to Content
0
Former Member
Jun 29, 2011 at 01:18 PM

CR2008 Distinct Records

18 Views

Hi All,

I have been able to connect and fetch data from sap tables into Crystal reports.I am using only links tab to setup links and fetch data from the SAP database.I have been able to fetch data for all the fields.Now the problem is duplicate records.I am getting around 4 records for each entry.I want to eliminate the duplication using the distinct feature or similar in SQL.All column values for the 4 records are the same.

Kindly advise on how to remove the duplicate records and make sure I have only 1 record

Thanks in advance