SSRS - Teradata multivalue parameter
<p>I'm using SSRS with teradata DB, trying to pass multivalue parameter to the DB.</p>

<p>I knew that this is an issue with SSRS &amp; Teradata, but I found something weird. It's possible to pass multivalue param, but only if it's the <strong>first</strong> parameter in the query:</p>

<pre><code>SELECT * FROM  ts
WHERE LOT in (?) AND Start_Date &gt;= ? AND Start_Date &lt;= ? AND Program like ?||'%'
</code></pre>

<p>If I make change and the condition "LOT in (?)" is not the first one, i get error..</p>

<p>UPDATE:
I just notice that the location in the query isn't relevant. What that changed is the order of the parameters in "Dataset Properties" (I'm using microsoft Report Builder):</p>

<p><a href="https://i.stack.imgur.com/ELOnq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ELOnq.png" alt="enter image description here"></a></p>