If statment

[nana_81]

i have added a parameter wich has a selection ( start date and process date)
if user select start date then
select statment 1
else
select statment 2
end if

ive tried to write this if statment inside Dataset but give me an error
this designer doesnt graphically support the IF SQL construct

[Hack]

What is the error that you are getting?

Please post the actual code that you are using.

[nana_81]

if @procDate ="Start Date" 
             SELECT *
             FROM         TableName
             WHERE     (Field1 >= @ProcDate1) AND (Field1<= @ProcDate2) 
else
            SELECT *
            FROM         TableName
            WHERE     (Field2 >= @ProcDate1) AND (Field2 <= @ProcDate2)

error
This designer does not graphically support the IF SQL construct.

Note ProcDate is a parameter which has 2 options Start date and process Date