Conditional Query Problem

[AIMS]

I am using CR 8.5 and initially was using the following query;

if {stpuw_slide_labels.specimen_desc} like ('*transplant') then crGray else defaultattribute

This worked great until my end users also mentioned that another group needed to be added. So I modified the above query to what is below, but I don't get shading on both parameters, only the first one. What's wrong?

if ({stpuw_slide_labels.specimen_desc} like ('*transplant') or
{stpuw_slide_labels.specimen_desc} like ('native liver')) then crGray else defaultattribute

 

[Turkbear]

Hi,
No wild card in second Like statement - typo or mistake?

 

[AIMS]

No there is no typo or wild card. Should I use an =?

 

[lbass]

The only way I could recreate your problem was by adding extra spaces around 'native liver'. First you should probably check to see if the field prints results with native liver as separate words, and then you might try trimming the database field, as in:

if trim({stpuw_slide_labels.specimen_desc}) like '*transplant' or
trim({stpuw_slide_labels.specimen_desc}) like 'native liver' then crGray else defaultattribute

-LB

 

[AIMS]

Guess what, it's case sensitive. I changed native to Native and it works. Thanks