CODEWITHSUNDEEP
ssrs-2008reporting-services
user1531539
user1531539

Reputation: 13

In SSRS, How to show two columns in drop down of parameter value?

In SSRS, How to show two columns in drop down of parameter value ? For Example, how to show Product id and Name in drop down of parameter ? Thanks in advance

Upvotes: 0

Views: 2808

Answers (1)

Ian Preston
Ian Preston

Reputation: 39586

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

Upvotes: 2

Related Questions