Select wildcard

[Nerdhurd]

Greetings,

I am using crystal 8.5 connecting via ODBC to a progress database and was wondering if there is a wildcard value I could use? like * or something? I need to use a character as a wildcard because I want to setup multiple select conditions that the user can choose to change at run time...and if they don't change them then they will be basically ignored with the wildcard

 

[rosemaryl]

Dear Nerdhurd,

I don't think you don't need a wildcard ...

What does your selection criteria look like right now?

I assume you are using parameters. You can provide a value like ALL to indicate that for each parameter.

(
If {?Myparameter} <> 'ALL'
then {Table.Field} = {?Myparameter}
else if {?Myparameter} = 'ALL'
then true
)

Is that what you are looking to do? You can string multiples of these statements together separated by an AND so that if you have multiple parameters you want to test against ... it works for each statement.

It doesn't have to be as simplistic as above. More info will help.

regards,

ro


Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762

 

[Turkbear]

Hi,
Where do you plan to use this?
If as a user-entered parameter that will be passed to a Selection Criteria formula( a where clause) then
why use * as one of the default parameter values and test for it:
(If {?parameter} = '*' then
True
else if {parameter} <> '*' then
{Databasetable.fieldname} = {?parameter})






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Nerdhurd]

Holycow thanks a bunch to both of you!

I hadn't even noticed parameters...I was just using my conditions in the select expert. Parameters do EXACTALLY what I needed, and then some!