Remove Duplicates in Crystal Reports (1 Viewer)

[cybermatrix]

I need to be able to remove duplicates in a report. I have tried the different features such as Suppress if duplicated.

The report is showing everything to do with the client and I only want to show what is the current service the client is receiving.

Data looks like
CID, CName, CAddress, CService, CRoute, CBilling, CBalance
123, Bill, 123 Main, Mon3, 200, 39,0
123, Bill, 123 Main, Mon3, 200, 39,0
123, Bill, 123 Main, Mon3, 200, 39,0
123, Bill, 123 Main, Mon3, 200, 39,0
123, Bill, 123 Main, Mon3, 200, 39,0
123, Bill, 123 Main, Tue1, 200, 39,0

Want to only show only the last value as shown for each client
123, Bill, 123 Main, Mon3, 200, 39,0

You would think that Suppress if duplicated would work but it does not. And the value that might change could be the price or balance. It is not always the CRoute that might changed.

The report shows over 150K rows of data and it really is only about 6K rows of data. The customer data is updated often and values can change. Some customer may have 2 - 3 current services but only started with 1 when they started.

 

[kevlray]

You need to find a way of grouping and put the data in the Group Footer and suppress the details. If the CID is unique, then that might be the best way to group.

I hope this helps.

 

[cybermatrix]

Grouping did not work I tried that for this and I was able to figure it out. I went into the database table linking area and removed some of the links to different tables and created a few new ones and it worked like a charm.

Thanks for the reply.

 

[kevlray]

Getting the links right will take care of a lot of issues. Glad you were able to find a solution.

 

[Mohanbabu.Pandari]

Enable "select Distinct Records" option in File >>Report Options.

Thanks
Mohanbabu Pandari