Solved

# How to enter a Like parameter

Posted on 2015-01-20
125 Views
I have a report whereby I have a parameter to select ALL or a task
I have created the following forula
if {?Task Number} ='ALL' then 1 else
How can i modify this to be able to select some tasks by inputtin example RS%

Gordon
0
Question by:GiaHughes
• 5
• 3
• 2
• +2

LVL 48

Expert Comment

Maybe

Regards
0

Author Comment

Hi
Tried
if {?Task Number} ='ALL' then 1 else
if {?Task Number} like 'RS%' then 0 else 1

But does not work

Gordon
0

LVL 48

Expert Comment

and with *
0

Author Comment

Hi

Does not work with the * either
I think it needs to know what field it is looking at so I think the formula should include a variant
of

Gordon
0

LVL 48

Expert Comment

Sorry can't help further
0

Author Comment

Gordon
0

LVL 18

Expert Comment

I believe it should be the opposite

if {?Task Number} ='ALL' then 1 else
if {?Task Number} like 'RS*' then 1 else 0

You may need to replace * with %
0

Author Comment

Hi

What I am trying to do is give an option to see ALL the tasks or select part of the task number
The current formula works ok if you select ALL or a complete task number
Does this make sense

Gordon
0

LVL 18

Expert Comment

then try

if {?Task Number} ='ALL' then 1 else

but this will return 1 if the parameter value is ALL or NOT like {?Task Number}

If you want just to filter the data add this to the Record Selection Formula

0

LVL 100

Expert Comment

Assuming you want it to match the first characters then it is

{Product.Product Name} LIKE {?ProductName} & "*"

Where are you using the formula?

If it is in the Select Expert then the formula has to return TRUE or FALSE

mlmcc
0

Author Comment

Hi mimcc

I have a parameter field {Task Number} that says ALL  and allows Custom Values, Multiple values and Discrete values

To make this work I have a formla {Task Number} :-
if {?Task Number} ='ALL' then 1 else

Then in the Select Expert @Task Number say is equal to 1.00

This all works fine if I want to see all the tasks or I can add the complete task numbers as a selection

What I would like to be able to do is to either select ALl or Enter the complete task number or select some of the task number i.e. RS% or %RS% etc

Hope this makes sense, so what do I need to modify?
Gordon
0

LVL 100

Accepted Solution

mlmcc earned 250 total points
I don't see the need for the TaskNumber formula but that may make it easier for you to understand.  One issue with it is the selection criteria won't be passed to the database for filtering so the report could run slower.

To me I think you have the formula reversed onthe last test
I think it should be
``````{Task Number} :-
1
1
else
0
``````

Do you expect the user to enter the wildcard?
If so this should work.  User should enter * for the wildcard.  Crystal will convert it to the appropriate value for the database.

``````{Task Number} :-
1
1
else
0
``````

If you want to handle the wildcard rather than require the user to enter  *RS*  or *RS  or RS*
you will need to decide if to always add the wildcard to what the user enters or to try to determine if it should be added.

mlmcc
0

LVL 34

Assisted Solution

James0628 earned 250 total points
Some of this has already been covered, but if the parameter allows multiple values, but _not_ ranges, then a test like ( {field} like {?parameter} ) should work, but the user will have to enter any wildcards (*).  You can't use something like {?parameter} + "*" to add the wildcard, because CR treats a multi-value parameter like an array, so {?parameter} + "*" just adds the "*" as another element in the array, and you end up with the last test being {field} like "*", which matches everything.

James
0

## Featured Post

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…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
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…