title: SSRS parameter usage in where clause
body: <p>Hi I have one column HOLDJOB in SQL table. There are two values for this 1 or 0. I need to show in the SSRS report of onHold parameter is true then exclude the results with <code>ONHOLD ='1'</code>. If it is false. then report should show all results with onhold 1 or 0</p>
  
  <p>Thanks in advance</p>
  
  <p>I have put <code>AND p6.HOLDJOB =@OnHold</code> this filter in the query. And on the report I have defined parameter like <code>IF Yes='0'</code>. This is working fine. How can show all records when selection is No. I mean I have to exclude this condition</p>