CODEWITHSUNDEEP
reporting-servicesparametersssrs-2012
Guava555
Guava555

Reputation: 11

SSRS Concatenated field parameter

enter image description here

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.

SELECT        CAST(DeliverableID AS NVARCHAR) + ' ' + CAST(Name AS NVARCHAR) AS ConcatDeliverableName
FROM            DeliverableTasks
ORDER BY DeliverableID

enter image description here

Upvotes: 1

Views: 212

Answers (1)

Nemanja Todorovic
Nemanja Todorovic

Reputation: 2800

You have problem with select that returns data for DataSet called RequiredParameters, and it says in error itself that it is about converting some nvarchar to int. You should try to execute just that sql script/sp to see if it runs properly.

Upvotes: 1

Related Questions