Working with "duplicate" records

[fort]

Hi,
I have been trying to make a report pulling out items with duplicate records. I am trying to get the same manufacturer name and having the same manufacturer number.

I have tried using PreviousValue--using it I pulled up the whole database, stating which ones were duplicated. But I need this sorted out with only printing 1 name and number for each record which is duplicated. I also tried going into the Database link on the CR form , trying to use "Select Distinct Records", but it was not available.

I am using Windows 2000 and Crystal Reports 8.
Any ideas??

Thanks!!

 

[dgillz]

"Select Distinct Records" should be available as long as you are using an ODBC data source. What type of data are you using? Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[fort]

I have been testing through an Access database, but I am going to switch it over to ODBC, after I get it pulling up the correct data. Do I need to switch it over before then?