Excluding fields that begin with certain characters... 1

[rji1124]

Hi, I am using CR9... I want to exclude entries in my reports that start with the words "IN QUEUE" in a brief description line... I put this entry in my Group selection formula (but it still selects tickets with this as the first characters in the field)...

and not ({probsummarym1.brief.description} startswith "IN QUEUE")

Any help is appreciated...

 

[lbass]

That should work, although you could be doing this in the record selection formula instead of the group selection formula. Are you sure the words appear in caps? You should place the field in the detail section and observe whether there is any variation. You might also try:

not (trim({probsummarym1.brief.description}) startswith "IN QUEUE")

...in case there are leading spaces.

-LB

 

[rji1124]

Thanks! it was indeed some a leading space! You have saved my life this week. Thanks