Parameter Checking

[enigma333]

Need to add logic to selection formula something like this

if ?Param is null then
show all records
else
show where field = ?Param

 

[kenhamady]

I don't think that a parameter can be null, it can be blank or zero. I like to use a specific value like:

(if {?Param} = "All"
then True
else {field} = {?Param})

Put this rule in a pair of parentheses if there are other rules in the selection formula. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[enigma333]

Perfect