title: How can I test for two field values in an SSRS Textbox's Expression property?
body: <p>I successfully use this Expression in a Textbox:</p>
  
  <pre><code>=IIF((Fields!Week.Value="WK1"),Fields!Price.Value,"")
  </code></pre>
  
  <p>I need to be more granular, though - not only am I looking for a Week value of "WK1" for this particular column before assigning it the value of the Price field, but also based on the value of the Unit field. </p>
  
  <p>So I would expect an expression like this to work:</p>
  
  <pre><code>=IIF((Fields!Week.Value="WK1" &amp;&amp; Fields!Unit.Value="Rock Bottom"),Fields!Price.Value,"")
  </code></pre>
  
  <p>...or else this:</p>
  
  <pre><code>=IIF(((Fields!Week.Value="WK1") &amp;&amp; (Fields!Unit.Value="Rock Bottom")),Fields!Price.Value,"")
  </code></pre>
  
  <p>...but when I try previewing the results after either of those, I get, "<em>The report preview failed because the report could not be built. Read the errors, warnings, and messages in the Error List window for specific build failures.</em>"</p>
  
  <p>That message is: </p>
  
  <blockquote>
    <p>[rsCompilerErrorInExpression] The Value expression for the textrun
    ‘TextboxCraftworksPriceWk1Data.Paragraphs[0].TextRuns[0]’ contains an
    error: [BC30201] Expression expected.</p>
  </blockquote>
  
  <p>So it says an expression is expected; how are those expressions not expressions?</p>
  
  <p>Now I've got John Mellencamp's "<em>Without Expression</em>" tune zipping through my mind's ears.</p>