How to set parameter value to "All" 1

[renee35]

I am just getting back into Crystal XI after being out for a couple of years. I am trying to figure out how to set a parameter value to "ALL"? For example, I want to be able to select a particular Employee or "All" employees?

Any help would be appreciated!

Thanks!!

Thanks a bunch!!

-T

 

[RCAIVANO69]

IF {?Employee}<> 0 THEN {table.employee}={?Employee} ELSE {table.employee}={table.employee}

 

[pgevaux]

({?ParameterName} = "All" or
{Table.Field} = {?ParameterName})

This is what I use.
Regards
Phil

 

[pgevaux]

In the record selection that is.

 

[renee35]

Thanks a bunch for both options!!

Thanks a bunch!!

-T

 

[renee35]

Quick question, how do you set the parameter to "All" if it's a number? If I use the 2nd sample, I get an error message: "A number is required here'?

Thanks again for any assistance!!

Thanks a bunch!!

-T

 

[lbass]

Add the value 0 to your parameter pick list, with "All" as the description. Then set up your record selection formula like this:

(
if {?Parm} <> 0 then
{table.emplno} = {?Parm} else
if {?Parm} = 0 then
true
)

-LB