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...