bmhardy_05
asked on
Highlighting duplicate lines in Crystal 10
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.
Thanks
Report.bmp
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.
Thanks
Report.bmp
ASKER
Hi Peter,
Are you saying it's best to design a separate report using the same fields but grouped differently? To be honest I don't necessarily need it all in one report so a separate one is feasible.
Do you know of a way I can develop a new version of the report to just show the duplicates?
Sorry about this I may be asking a bit much here.
Are you saying it's best to design a separate report using the same fields but grouped differently? To be honest I don't necessarily need it all in one report so a separate one is feasible.
Do you know of a way I can develop a new version of the report to just show the duplicates?
Sorry about this I may be asking a bit much here.
Whatever the next step is, I need to know why the records are not being sorted next to each other at the moment if theye are duplicates.
Next and Previous refer to records in the recordset for the report. Crystal is able to look ahead/back 1 record.
If records are true duplicates then they should sort/group together.
mlmcc
If records are true duplicates then they should sort/group together.
mlmcc
ASKER
I think my problem is that I have 3 lines grouped which all contain roughly the same data other than the rates. This means that when I use 'next' or 'previous' it picks all of them up as duplicates.
Ideally what I am looking for is any duplication of the group of data if possible.
I have attached a more suitable image of what I am looking for.
Report.bmp
Ideally what I am looking for is any duplication of the group of data if possible.
I have attached a more suitable image of what I am looking for.
Report.bmp
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The answers, although being questions to find out more information, provided me with a different direction to get the data I needed.
Not in any practicable way.
Looks like you will need another report which sorts records by these fields to highlight duplicates .
(Although I find it difficult to understand what report sequence you would be using that put 'duplicate' records in different parts of the report.)