I have used 'like' in Report -> Selection Formula -> Record:

{HEADING_sub.HEAD} like {?subjects}

 

In the parameter prompt I gave instructions to user by typing

*Search Term*. ( with both * at the begining and the end of the Term). But the user doesn't like typing '*', they awlays want to type search term directly.

However typing * or not  typing * will return quite different set of records.

With * , there are more hits than without *.

Could anyone advise how to integrate * in the {HEADING_sub.HEAD} like {?subjects} above without typing * at the parameter prompt?

thanks in advance.

 

John

 

the first option result in CR returning everything! I don't think it's searching the 'Term' typed in the parameter prompt.

the second option has an error "The array must be subscripted, e.g. Array"

 

No, it does not take multiple values; it only allows to search a term at a time as instructed to the user, e.g. *nursing* in my original approach, tt results returns well but the user doesn't like to type *.

 

John

 

thank you very much for pointing out...I was acutally doing 'allow multiple values ' but I gave up, and forgot to set that back to false. Yes, after using the first option you have advised, it works now.

However I will have to go back to check  the user's specification whether it requires multiple values or not. But searching multiple terms in differnt subject areas would not make sense in this report. For exmaple, searching 'nursing' only want to find nursing related information. When searching 'nursing' and 'engineering' would not make sense. If they require multiple values even in one subject area, I think I will refer to the example in the link you advised earlier.  Thank you very much for your help.

John