Selection Formula One, The Other, or Both

[Jillp]

I need to have user select Company1, Company2, or Both. I have set up a parameter that asks user to type 1, 2, or B. I cannot figure out how to get Both to work in the select expert. I'm sure this is easy -- I just haven't thought of it yet.

Thanks,

Jill

 

[CR85user]

If {?param1} like '1' then {your.otherfield} in {Company1.field} else
If {?param1} like '2' then {your.otherfield} in {Company2.field} else
If {?param1} like 'B' then ({your.otherfield} in {Company1.field} or {your.otherfield} in {Company2.field}) else true

You can change your param to display descriptions instead for ease of use for your users. Add desciptions display desription only and read in the value as above in the selection criteria.

'J

CR8.5 / CRXI - Discovering the impossible

 

[CR85user]

Note: If by both you mean that it must be present in both then change the 3rd condition to:

If {?param1} like 'B' then ({your.otherfield} in {Company1.field} and {your.otherfield} in {Company2.field}) else true

The 1st post is for the other parameter or field to be present in either.

'J

CR8.5 / CRXI - Discovering the impossible

 

[Jillp]

J

Thanks so much. I never would have figured it out. It's quite different then where I was going with it.

Jill