Showing results for 
Search instead for 
Did you mean: 

How to force removal of duplicated records?

0 Kudos

How do you force the removal of duplicated records. What are the trick of the trades codes or formula that you use to remove these records. I have search all over the internet, but can't find that perfect solution. I tried to use the Previous() Statement, but it will not work correctly when its time to filter on it. The report is pulling in duplicated records, and I know what field is causing it, but I need that field for the report. So, how can force the one of the records to not show? Help please!

View Entire Topic
Active Contributor
0 Kudos

If you are getting your results from Query then add group by clause in your query