This one's a bit of strange one. I have contractors who work on placements at various sites and have 3 rates of pay available each (Daily, half daily and hourly).
The report currently groups them to show all the different placements and the different rates of pay. I have attached an example of what it currently produces.
Sometimes these placements can be added on the system twice so I need a field or a way of highlighting if the line has been duplicated (same name, client, rates etc.)
I have spotted a couple of forums that mention the 'next' and 'previous' functions but these only appear to help comparing lines that appear next to each other.
Is there a way I can compare the whole report to highlight duplicates?
My knowledge of Crystal is not advanced but OK so as much detail as possible please.