SQL Script when using XL Report Generator

Question

select Bidders.*
From Bidders
where
If (:Param1 = 1) Then
   Due > 0 and
   Left(Event,2) <> 12
Else
   Due = 0) and
   Left(Event,2) <> 12
End If
order by
      Name

Answer 1

select Bidders.*
From Bidders
where (:Param1 = 1 and Due > 0 and Left(Event,2) <> 12) or
      (:Param1 <> 1 and Due = 0 and Left(Event,2) <> 12)
order by Name;