Formula 1

[golden1]

Does anyone know how to create a formula to say 'Does not contain'?

 

[lbass]

There is more than one way to do this, but you haven't explained what you mean. I'm going to take a wild guess that what you really want to determine is whether there is a certain value in some set of records, i.e., per group. One sentence questions rarely provide enough info for a meaningful response. Please take the time to be more specific.

-LB

 

[golden1]

Hi - sorry for not being more specific. I actually wanted to see something that 'contains', not 'does not contain'. I want to say:

if {DNUCLEUS.NAME} contains "do not use" then Suppress

Thanks for your help.

Eve

 

[Turkbear]

Hi,
Would that field have more in it,
like
'do not use this record for data'
or does it have just
'do not use' ?
in the ones you want to suppress?




To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[golden1]

Hi

This field is the name of the client.

Some of the clients have been set up with 'clientname - DO NOT USE'. I want to suppress any clients with DO NOT USE from my report.

Thanks

Eve

 

[jmd0252]

Here is a way,,
I am using my inventory file where some description are entered do not use,, this give me a list of all of them
{IM_ITEMFILE.DESCRIPTION} like "*DO NOT USE"

You could do the same and say IS NOT LIKE..

 

[CoSpringsGuy]

Instead of suppression (maybe semantics) use your record selection expert
//
instr({DNUCLEUS.NAME},'DO NOT USE')>0

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[lbass]

I would allow for different cases:

ucase({table.field}) like "*DO NOT USE*"

-LB

 

[golden1]

I used:

ucase({table.field}) like "*DO NOT USE*"

this worked perfectly.

Thank you all for your responses.

Eve