Add all parameters 2

[micro2005]

SQL server 2000 with Crystal Reports v10.
I have a string filed called area. I have to add this as a parameter to my report. I created a new paramter and selected the default values.
What I need now is to create a value called "ALL" which will select all the values automatically so that the user does not have to do it.
Can someone please tell me how to do this?

Thanks in advance!

 

[BParsons]

Something like this in your select expert should work;

(If {?Parameter} <> "ALL" then
{table.field} = {?Parameter}
else If {?Parameter} = "ALL" then true)

 

[lbass]

Be sure to add "All" (without the "") to your default values list.

-LB

 

[micro2005]

Thank you both, it works great!

 

[synapsevampire]

Check my FAQ for making sure that this passes to the database, and note the referenced FAQ for displaying the choices made:

faq767-3825

-k