?
Solved

Using a Wildcard with a Parameter

Posted on 2009-05-20
7
Medium Priority
?
389 Views
Last Modified: 2012-05-07
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
Comment
Question by:tpomeroy
  • 4
  • 3
7 Comments
 
LVL 101

Accepted Solution

by:
mlmcc earned 500 total points
ID: 24433523
Try

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

mlmcc
0
 

Author Comment

by:tpomeroy
ID: 24433565
When I used this, I received this error message:  "This array must be subscripted.  For example: Array [i]."
error.bmp
0
 

Author Comment

by:tpomeroy
ID: 24433686
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: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 101

Expert Comment

by:mlmcc
ID: 24434107
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
 

Author Comment

by:tpomeroy
ID: 24434541
I could but there are hundreds of them.  I will try that, though.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 24435011
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
 

Author Comment

by:tpomeroy
ID: 24435121
No it does not.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Planning to migrate your EDB file(s) to a new or an existing Outlook PST file? This video will guide you how to convert EDB file(s) to PST. Besides this, it also describes, how one can easily search any item(s) from multiple folders or mailboxes…
Suggested Courses
Course of the Month9 days, 9 hours left to enroll

609 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question