title: SSRS - Proper syntax for expression value for IN filter having multiple integers?
body: <p>This seems like it should be simple but I can't seem to get the proper syntax.</p>
  <p>I'm trying to add a filter to a dataset, where the values need to be based on a parameter value.</p>
  <p>I know I can do a basic IN filter like this (the parameter named MyField is of type INT):</p>
  <p><code>Expression: [MyField]</code><br />
  <code>Operator: In</code><br />
  <code>Value: 4,5</code></p>
  <p>The dataset only returns records where MyField is 4 or 5.</p>
  <p>But, I only want to show 4 &amp; 5 if MyParameter = 1 or 2. Otherwise I want to show 5 &amp; 6. I tried setting an expression for the value like:</p>
  <p><code>=IIf(Parameters!Timeframe.Value = 1 OR Parameters!Timeframe.Value = 2, &quot;4,5&quot;, &quot;5,6&quot;)</code></p>
  <p>This results in an error about &quot;Cannot compare data of types System.Int64 and System.String&quot;.</p>
  <p>I also tried:</p>
  <p><code>=IIf(Parameters!Timeframe.Value = 1 OR Parameters!Timeframe.Value = 2, &quot;CInt(4),CInt(5)&quot;, &quot;CInt(5),CInt(6)&quot;)</code></p>
  <p>But that gave the same error. How to I pass multiple integers like this?</p>
  <p>Thanks!</p>