Parameter with Wildcard? 1

[rbh123456789]

CR 11.5

Hey guys,

Here is my record selection formula:

if {RESPONDENT_LOOKUP.respname} = {?respsearch} then true;

What happens:

When i am prompted with the {?respsearch} parameter, i would type in, for example, City of Toronto or Microsoft Inc. The search results bring back the EXACT matches, which is good.

What i need to happen:

I need the search results to not only display the EXACT matches, but similar records like 'The City of Toronto' or 'City of Toronto - Finance Dept'.

Can anyone help?

 

[rbh123456789]

I just changed by forumla to:

if {RESPONDENT_LOOKUP.respname} like ["*" + {?respsearch} + "*"] then true;

Does anyone see a potential problem with it?
The records seem to be displaying correctly.

 

[rbh123456789]

Update:

I am now experincing a problem when i have 2 forumlas in the statement:

(if {RESPONDENT_LOOKUP.compname} = {?compsearch} then true);

(if {RESPONDENT_LOOKUP.respname} like ["*" + {?respsearch} + "*"] then true);

Basically, the {?respsearch} works fine, but when the {?compsearch} is used, the records are not filtered.

These two parameters are used independantly, never two at one time.

 

[lbass]

(
{RESPONDENT_LOOKUP.compname} = {?compsearch} or
{RESPONDENT_LOOKUP.respname} like "*" + {?respsearch} + "*"
)

...if you mean a record must meet one of the above criteria.

-LB

 

[rbh123456789]

Hello lbass,

I got the same results as my own formula.
The {?compsearch} param does not filter, but the {?respsearch} does what it is supposed to.

And yes, only one of the params when the report is executed. The user is either going to search for then Person (comp) by name, or the Organization (resp) by name.

 

[lbass]

Each prompt needs a default, say let's say you set it up as "None". Use prompt text to instruct the user to choose "None" if not using the parameter. Then change the formula to:

(
(
{?compsearch} <> "None" and
{RESPONDENT_LOOKUP.compname} = {?compsearch}
) or
(
{?respsearch} <> "None" and
{RESPONDENT_LOOKUP.respname} like "*" + {?respsearch} + "*"
)
)

-LB

 

[rbh123456789]

Thanks lbass, thats exactly what i needed.