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

<p>I need to create an SSRS report parameter by combining two fields the deliverable ID and deliverable name. I was able to do that using an SQL quire , however when I click on "View Report". I get an error message. My drop down list of parameters, my quire and the error message attached as images for your reference.</p>

<pre><code>SELECT        CAST(DeliverableID AS NVARCHAR) + ' ' + CAST(Name AS NVARCHAR) AS ConcatDeliverableName
FROM            DeliverableTasks
ORDER BY DeliverableID
</code></pre>

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