how to add multiple columns to drop down list - SSRS

-
down voteaccepted
I would create a Calculated Field which concatenates the ProductID and ProductName in the Dataset you're using to populate your Parameter.
e.g. with the Dataset:
enter image description here
I created a new Calculated Field called ProductIDName with the expression:
=CStr(Fields!ProductID.Value) & ": " & Fields!ProductName.Value
Now use this new field to populate your Parameter:
enter image description here
End result:
enter image description here

Comments

Post a Comment