optional parameter issue

[rreddy01]

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

 

[IanWaterman]

Try

(IF not(hasvalue({?Name}) = true) then ({AV_ACTIVITY_TIS1.UC02} = {?Name}) else True)

The "else true" effectively ignores the filter.

Ian

 

[rreddy01]

Thanks for your reply and that worked for me.

 

[bandarna]

Hi,
while serching how to create optional parameters in Crystal report, I found this thred is very much lelpfull tome. looks like it is working for someone. I wrote this code in Select Expert (CR XI Ver.). but I am getting error as " The ) is missing"

(IF not(hasvalue({?P_Element_2}) = true) then ({v_FRD308R_EN.element_2} = {?P_Element_2}) else true)

I am new need to CR, need help.

I wrote above code in Select Expert. is ths right place? or do we have to write this code in formual field?

my parameter name is Dinamic picklist with Range, currently user is selecting both from and to IDs, I wanted them to make an optional.

-bnr