Hi,

First post and in need of some help.

I have created a simple report taking out from our MSSQL database data: 'jobnumber' and 'quote amount' plus some other info such as contact details etc...

In our database we have some duplicate entries so on this report I often get duplicate results. I cannot remove the duplicate entries from the database as they are needed - so can I get Crystal Reports to take out all the duplicate job numbers in the report unless the quote amount is different?

Thanks
James

Field job_number - data usually just 123456 format
Field quoted_value - data £999,999 format

Often though we have a few records on the report duplicated as often we send out multiple quotes for one job as we quote the same amount to each of the people who may do the work.

Basically I am trying to add up all the sent out quotes for a particular time frame. It is all working except this duplicate results for some jobs.

 I need something along the lines of either remove or display in red or something so I can identify them - where the job number is a duplicate and also the quote amount is duplicate.

If the job number is the same but the quote amount is different then that if fine and nothing needs to be done about it.

Thanks
James

Yes at the minute all the job numbers are displaced in order so I can see all the duplicates and they are under each other for example it goes job: 1123, 1124, 1125, 1125, 1125 all with quotes next to them.

I just want to stand out - perhaps make all the duplicate font colour Red?

Thanks
James