title: Dealing with blank or null in ssrs
body: <p>In my report, I have an expression which is used to pass a parameter to a child report parameter which is set to allow null values. The expression is :
  =IIf(Parameters!Lead.Value = "False",Nothing,Fields!Paid.Value) </p>
  
  <p>The above expression returns values only when Fields!Paid.Value is not blank. Therefore when Fields!Paid.Value is blank I get an error </p>
  
  <p>"the value provided for the report parameter is not valid"</p>
  
  <p>How do I modify my expression to parse these two conflicting issues?</p>
  
  <p>What I want is to be able to return values when the Fields!Paid.Value is blank or when it is not. So at all time when the expression runs corresponding values are returned without the error stated above.</p>
  
  <p>Thanks for helping out.</p>