Results based from parameters

[Csukardi151]

Hello all,

I believe I'm trying to do a very simple thing in Crystal 11 but for the life can't figure it out.

I have a table (lets call it {Letters}) that has 3 fields A, B and C.

Now what I currently have working, I have a parameter that has the user choose A, B or C and I have in the Selection Formulas: Record, "{Letters}={?Item}". This works!

Now I want that to continue to work while also having an extra parameter called "All" which will show all letters instead of just individual letters.

I've tried making some If/Then commands but my syntax must be way off cause all I get are errors.

Any help would be appreciated!

Thank you,
Steve

 

[DJWheezyWeez]

If I'm understanding your problem correctly, if you edit your {?Item} parameter, there's an option called "Allow multiple values". If you make this true then you can select multiple values. Problem is you need to type in what you want and if you don't know what you want then you're out of luck. You can also make this parameter Dynamic then choose your table and make "Allow multiple values" true again. When you run the report, you'll get a list of data to choose from if you don't know the name of something that you want to include in the report.

I hope this is sort of what you're looking for and I hope it helps.

-DJWW

 

[dunlop1975]

If you specifically want a parameter option called ALL then:

(if {?Item} = "ALL" then {Letters} like "*"
else {Letters} = {?Item})

 

[dunlop1975]

<your other selection statements> AND

(if {?Item} = "ALL" then {Letters} like "*"
else {Letters} = {?Item}) AND
.
.
.

 

[Csukardi151]

Thanks for the replies. I'll give those ideas a shot in a little bit!

 

[lbass]

You could use:

(
(
{?Item} <> "All" and
{table.letter} = {?Item}
) or
{?Item} = "All"
)

-LB