Hi,

While searching how to create optional parameters in Crystal report, I found below  thread

http://www.tek-tips.com/viewthread.cfm?qid=1685205

 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 wrote above code in Select Expert. is this right place? or do we have to write this code in formula field?

My parameter name is Dynamic pick list with Range, currently user is selecting both from and to IDs, I wanted them to make an optional.

bnr

Sastry,