I am trying to create an optional parameter in crystal reports 2008.
There is a parameter field called Name which is given as optional..
if they dont enter anyvalue in the parameter it should pick up ALL values..I have defaulted the parameter to 'ALL' in parameter list but when they want to choose any one value from drop down its not working...
tried this but its still not working.
((not HasValue({?Name})) or ISNULL({?Name}) or {?Name} ='' OR ({AV_ACTIVITY_TIS1.UC02} = {?Name}))
when i try to use the below code its says boolean is required.
(IF not(hasvalue({?Name}) = true) then ({AV_ACTIVITY_TIS1.UC02} = {?Name}) else "ALL")
Any help is greatly appreciated.
Thanks,
rreddy
There is a parameter field called Name which is given as optional..
if they dont enter anyvalue in the parameter it should pick up ALL values..I have defaulted the parameter to 'ALL' in parameter list but when they want to choose any one value from drop down its not working...
tried this but its still not working.
((not HasValue({?Name})) or ISNULL({?Name}) or {?Name} ='' OR ({AV_ACTIVITY_TIS1.UC02} = {?Name}))
when i try to use the below code its says boolean is required.
(IF not(hasvalue({?Name}) = true) then ({AV_ACTIVITY_TIS1.UC02} = {?Name}) else "ALL")
Any help is greatly appreciated.
Thanks,
rreddy