Parameter within a Parameter (select ALL or SOME)

[HiHeidi]

I need give my users the choice of selecting ALL values of a field {@Offset} vs. selecting SOME of the values in that field.

I have a Parameter set up that asks for ALL or SELECT {?SelectOffset}. I also have another parameter field {?Offset} where users can then indicate what values they want to include. Finally, I have a formula field @allorselect with the following:
if {?SelectOffset} = "All" then {@Offset} else {?Offset}

When I call for the prompts both {?SelectOffset} and {?Offset} are listed. How do I have just {?SelectOffset} in the initial list and then based upon my choice (All or SELECT) the secondary parameter pops up.

FINALLY: What in the heck do I put into selection criteria???

Thank you sooo much! I'm under a tight deadline!

Heidi

 

[IdoMillet]

Heidi,

Create a single parameter that includes the possible choices as well as "ALL".

In your record selection logic you can have something like:
--------------------------------------------------
{Table.Field} = {?parameter} OR {?parameter}="ALL"
--------------------------------------------------

Cheers,
- Ido ixm7@psu.edu

 

[HiHeidi]

That worked! I think I was in too deep! Ever get lost in what you were doing? EEK!

Thank you Thank you Thank you!

-Heidi

 

[IdoMillet]

Thinking out of the box is always easier when you are outside the box... )

Cheers,
- Ido ixm7@psu.edu

 

[GaryWilsonCPA]

i like this method better than what i have been using - i modify the record selection to say like (?parameter) and then the user can use a *

Good tip