Using Select Expert to Filter Out One of 2 Similar Classifications 1

[dstalls]

This may already be on the site, but I can find it.

I am using the Select Expert to filter (something like below):

{Table_nme.field_nme} in ["Pea Pods"]

Somehow I am also getting values in "Pea" (which I don't want).

I tried:

({Table_nme.field_nme} in ["Pea Pods"] and
not({Table_nme.field_nme} in ["Pea"]))

but this isn't working. Does anyone have any suggestions?

 

[AndyMc]

dstalls,

try:

InStr{Table_nme.field_nme},"Pea Pods",1) > 0

Andy

 

[AndyMc]

I mean

InStr({Table_nme.field_nme},"Pea Pods",1) > 0

Andy

 

[dstalls]

Unfortunately that didn't work maybe because I have multiple conditions I'm trying to meet.

Here is the actual formula I have written:

{TCLIENT.LEGAL_CUSTODY_STATUS}= ["CPA LGL ADPT","DSS LGL ADPT","KIN ADPT","NONKIN ADPT"]

However an unwanted value named "DSS LGL" keeps finding its way into the report.

Any ideas how to work with that> Thanks!

 

[AndyMc]

try:

(
{TCLIENT.LEGAL_CUSTODY_STATUS} = "CPA LGL ADPT" or
{TCLIENT.LEGAL_CUSTODY_STATUS} = "DSS LGL ADPT" or
{TCLIENT.LEGAL_CUSTODY_STATUS} = "KIN ADPT" or
{TCLIENT.LEGAL_CUSTODY_STATUS} = "NONKIN ADPT"
)

Andy

 

[dstalls]

Still not working Andy. Its strange!

If you have any more ideas that would be great, but I do appreciate your time.

 

[dgillz]

Please cut and paste your entire record selection formuls to the thread.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[lbass]

Andy's last post should work perfectly. I think you should try it again, making sure you are using "=". Instead of saying something is "still not working", it is more productive to report back with the results you are getting, which can help clarify the issue.

-LB

 

[dstalls]

I apologize for being vague. It actually was another formula in the record selection that was preventing the desired result. Thank you to all!

Derik