Solved

Using a Wildcard with a Parameter

Posted on 2009-05-20
7
379 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 100

Accepted Solution

by:
mlmcc earned 125 total points
Comment Utility
Try

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

mlmcc
0
 

Author Comment

by:tpomeroy
Comment Utility
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
Comment Utility
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
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
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
Comment Utility
I could but there are hundreds of them.  I will try that, though.
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
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
Comment Utility
No it does not.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

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. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

771 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now