Duplicates in Crystal Reports

[jont]

Using Crystal to link between Actinic and back office database on the product reference. All is well but it also returns product duplicates (1!ref, 2!ref etc) ... any suggestions on how to filter the main product only would be greatly welcomed.

v8.5.0
Crystal v8.5 Pro

[jont]

I quit 5 minutes too soon .... in case of use to others ...

not ({Product.Product Reference} startswith ["1!", "2!", "3!", "4!"])

adding in more n! as required

[wjcampbe]

May be possible - and shorter to use

not ({Product.Product Reference} contains ["!"])

[jont]

That would be a more elegant (a powerful) solution .. tried it and Crystal does not appear to have the ability to use the operator "contains".

[wjcampbe]

It may be if InStr(Product.Product Reference, "!") or something similar - there may be info on matching a substring in the CR help.

[fergusw]

Quick check of CR function search results seems to indicate Bill's right.

 if instr({Product.Product Reference} ,"!") = 0 then

[wjcampbe]

Thanks Fergus.

Jont - Fergus code will need to be changed to

if instr({Product.Product Reference} ,"!") < 1 then

to give the 'not a duplicate' condition, but once working, will never need changed, no matter how many duplicates you have.

[fergusw]

Ahem - *cough* - don't know what you mean Never made that mistake

[wjcampbe]

Ahh! The power of the edit button

I'd still use < 1, just in case CR sees False as -1 the same as Visual Basic.

[fergusw]

Good point well made sir - I'll decline any further edits this time

[jont]

Cheers guys - as always more than one way to skin the cat.

Loving Crystal at the moment - only really dabbled with changing Actinic reports but the power of the thing is amazing.. I'm like a kid with a new toy at the moment