• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 376
  • Last Modified:

Show the related description for a id parameter

I have a parameter on my report where the user selects more than one item for a particular parameter. Currently the user selects a fields that is an
id.  Multiple selected items are displayed in the report header this way:

="Branch Selected :" & Join(Parameters!ItemCode.Label,", ")

Would it be possible to also display the description field that is related to the id(itemcode)?.....

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


The backend datasource is a SSAS Cube.
0
vbnetcoder
Asked:
vbnetcoder
  • 2
1 Solution
 
BitzuEECommented:
use:  Parameters!ItemCode.Value
0
 
TempDBACommented:
Check the dataset that populates the parameter. Since the parameter is populated based on the data at the backend, you must be getting it through some query. If not, and you have defined the values while designing the report itself, just check what is the value in the label, value field. This two field are different. Label says what you want to show and Value shows the exact value that will be used. So, if "label" of the parameter represents 1,2,3,etc, check if value represents Apple,Pear,etc or not. If yes, and you are not populating 1,2,3 as value too, then just use
"Branch Selected :" & Join(Parameters!ItemCode.Value.Tostring() + Parameters!ItemCode.Label,", ")
0
 
TempDBACommented:
0
 
vbnetcoderAuthor Commented:
ty
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now