I assume you're using
Parameters for this. What version of Crystal are you using?
I'm not sure whether this feature was available in XI and below, but in 2008 and above, you have the option of marking parameter as Optional. When you do that and set a default value of "All", you can go to the Select Expert and modify the selection formula to be something like this:
({?Status} = 'All' or {MyTable.Status} = {?Status}) and
({?Rec} = 'All' or {MyTable.Rec} = {?Rec})
Please note the use of parentheses - this will not work correctly if you don't use them where I've placed them.
-Dell
IP Logged
