title: SSRS Row Visibility Expression
body: <p>I have a report that has two date parameters (StartDate and StartInMarketDate). In some cases, the StartInMarketDate value is the database can be NULL. When either both parameters are NULL or the StartInMarketDate parameter is NULL, all records should appear on the report. When a date is given for the StartInMarketDate parameter and the StartDate is NULL, the report should exclude all records where the StartInMarketDate is NULL.</p>
  
  <p>I assume I should be able to resolve this issue hiding rows based on an expression, but I cannot get the correct syntax.</p>
  
  <p>Below is the syntax I came up with, but it includes all the records when I enter the StartInMarketDate parameter, and excludes the correct records when I use the StartDate parameter.</p>
  
  <pre><code>=IIF(IsNothing(Parameters!StartInMarketDate.Value), IIF(IsNothing(Fields!StartInMarketDate.Value), IIF(IsNothing(Parameters!StartDate.Value), False, True), False), False)
  </code></pre>
  
  <p>Any suggestions on where I'm going wrong is appreciated.</p>
  
  <p>Thanks.</p>