Display in the header what items where selected for a parameter.

I have a parameter on my report where the user selects more than one item for a particular parameter. I want to display in my header everything
that the user selected. How would i do so?
vbnetcoderAsked:
Who is Participating?
 
Simone BSenior E-Commerce AnalystCommented:
Here is a sample expression that I use in my report headers for the same purpose. In this example, it will list every branch selected in the BranchBranchName parameter.

="Branch Selected :" &Join(Parameters!BranchBranchName.Label,", ")
0
 
vbnetcoderAuthor Commented:
I have know problem doing it when i have one item but not sure what to do when the user selects more then one.
0
 
Simone BSenior E-Commerce AnalystCommented:
That was for a report whose data source is a cube. Similarly, you can use the same idea for a report whose data source is an SQL database, as in the example below. It just depends on whether you are displaying the labels or values. Sometimes there may be no difference in the two.

="Branch Selected: " & join(Parameters!BranchSelect.Value,", ")
0
 
vbnetcoderAuthor Commented:
Cool that worked. I am using a cube ....

What now is getting displayed is an id .... that the user had selected. Would it be possible to also display the description field that is related to the id.....

So for example it would display: 1 Apple, 2 Orange, 3 Pear.  Right now it is only displaying 1, 2, 3.

I will ask this question again under a new title: "Show the related description for a id parameter" if you want to get extra points.
0
 
vbnetcoderAuthor Commented:
ty
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.