Record selection using memo field - Crystal Reports 9

[Brian555]

I have a database of accidents, one field of which is a memo field that contains the accident description. I would like to be able to select records that, for example, contain the word "Escalator" in this memo field.

Is this possible?

Any suggestions would be very much appreciated

 

[kernal]

I'm using version 9 with a csv file that has a long character field. Try:

{field} like "*Escalator*

 

[kernal]

Sorry, I forgot to mention where to enter it. Select Report, Selection Formulas then Record.

 

[lbass]

I would accommodate variations in case by using:

ucase({table.field}) like "*ESCALATOR*"

Better yet, create a SQL expression {%memo}:

{fn ucase(`table`.`field`)}

{%memo} like "*ESCALATOR*"

-LB

 

[Brian555]

Thanks for your help - this has partially solved my problem. I would like to be able to input the keyword e.g Gondola via a parameter (string) but am having problems. My selection formula now looks like this:

{Sheet1_.storename} = {?storename} and
{Sheet1_.accidentdate} = {?accidentdate} and
ucase({Sheet1_.accidentdescription}) like "*{?Keyword}*" and
{Sheet1_.causeofinjury} = {?causeofinjury}

However, it does not appear to work.

Once again any suggestions would be most gratefully appreciated.

 

[lbass]

For parameters you have to set it up a little differently:

{Sheet1_.storename} = {?storename} and
{Sheet1_.accidentdate} = {?accidentdate} and
ucase({Sheet1_.accidentdescription}) like "*"+ucase({?Keyword})+"*" and
{Sheet1_.causeofinjury} = {?causeofinjury}

-LB

 

[Brian555]

That has sorted it.

Many thanks for your assistance

Brian