Show the related description for a id parameter

Posted on 2012-09-11
Last Modified: 2016-02-18
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.
Question by:vbnetcoder

    Expert Comment

    use:  Parameters!ItemCode.Value
    LVL 25

    Expert Comment

    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,", ")
    LVL 25

    Accepted Solution


    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    After much searching across the internet I have found that you could not set the name of the file you were attaching to dynamic report subscriptons in Microsoft Reporting Services. I did manage to find one article showing you how your could make a s…
    Introduction Earlier I wrote an article about the new lookup functions ( that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now