Highlighting Duplicates 1

[h1tman911]

Hi,

Newbie here, I am creating a report that has a field called serial number now hopefully every serial number should be different what I would like to do is if a duplicate serial number appears I would like it to be in bold or red just so it stands out hope that makes sense

cheers

Nick

 

[IdoMillet]

Use the Previous() function to check if

Previous({SerialN}) = {Serial_N}

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[h1tman911]

cheers,

would that check the last previous record or all prevous records ???

and how would I make the text red or bold.....???

I am a total newbie sorry about this



N!CK

 

[h1tman911]

right I got it working so it turns the text red however it only looks at the previous record and not all of them, how can I change it ????

 

[IdoMillet]

Extend the logic to also use Next()
that way, you can get all duplicate rows to highlight.

Another option, is to group by SerialN and check if the count of records for that serial number is greater than 1.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[h1tman911]

right cheers,

I don't really want to group by serial so how do I use the next() option ??? can you give me an example ????

at the moment I have:-

in the serial field/format field/font/color/x2

if previous ({serial}) = {serial}) then CRred

how do I introduce the next() command ????

many thanks

N!CK

 

[IdoMillet]

Use something like:
----------------------------------------
if (previous ({serial}) = {serial})) OR
(Next({serial}) = {serial})) then CRred
----------------------------------------

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[IdoMillet]

Cleaned up:
----------------------------------------
if (previous ({serial}) = {serial}) OR
(Next({serial}) = {serial}) then CRred
----------------------------------------

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[h1tman911]

Working fine now thanks for the info