• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 391
  • Last Modified:

Using a Wildcard with a Parameter

I am writing a report that will generate a list of survey recipients.  I have two parameters setup: one for the bank acronym and one for job title.  My problem is that, if the user enters only "Teller" in the parameter, it will only return Tellers.  However, there are job titles like Teller Supervisor and FSR/Teller that should also be returned.  I have tried using {Imaging.job_code} like "*{?Job Title}*" but no results are returned with this.  What other way can I use a wildcard with this parameter to get what I'm needing?


{@Status} = "A" and
not isnull ({Imaging.NovellID}) and
{@JobTitle} and
(if {?Bank Acronym} = "*" then true
    else {@Bank} = {?Bank Acronym}) and
{Imaging.job_code} like {?Job Title}

Open in new window

0
tpomeroy
Asked:
tpomeroy
  • 4
  • 3
1 Solution
 
mlmccCommented:
Try

{Imaging.job_code} like "*" & {?Job Title} & "*"

mlmcc
0
 
tpomeroyAuthor Commented:
When I used this, I received this error message:  "This array must be subscripted.  For example: Array [i]."
error.bmp
0
 
tpomeroyAuthor Commented:
Okay, I changed the "allow multiple values" in the parameter to False and the error went away.  However, the users really need the ability to enter multiple job titles.  Anyway around that?
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
mlmccCommented:
Not easily that I can think of.

Can you populate the parameter with valid values so they can choose all the ones they want?

mlmcc
0
 
tpomeroyAuthor Commented:
I could but there are hundreds of them.  I will try that, though.
0
 
mlmccCommented:
You can use the ability to add them from the table rather than having to add them.

If the user enters *Teller* as a value along with another value does it work if you use

{ReportField} LIKE {?Param}

mlmcc
0
 
tpomeroyAuthor Commented:
No it does not.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now