title: SSRS SQL Query display error after i add where clause
body: <p>I have a full query which can be display correctly in SSRS, however, when I add this <code>where</code> clause, I get an error </p>
  
  <blockquote>
    <p>Query execution failed for data set 'dataset1'. (rsErrorExecutingCommand)</p>
  </blockquote>
  
  <p>This is the <code>WHERE</code> clause I add:</p>
  
  <pre><code>where 
      (itemNo = @ItemNo or @ItemNo is NULL) 
      and (JobNo in (@JobNo) or @JobNo is NULL) 
      and (customerNo = @CustomerNo or @CustomerNo is NULL) 
      and (LotNo in (@LotNo) or @LotNo is NULL)
      and (Station = @Station or @Station is NULL) 
      and ((DateTimeStamp between @startDate and  @endDate) or (@startDate is null and @endDate is Null))
  </code></pre>
  
  <p>Do you guys have any idea what is the syntax error I did here?</p>