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

Posted on 2012-09-11
Last Modified: 2012-09-11
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?
Question by:vbnetcoder

    Author Comment

    I have know problem doing it when i have one item but not sure what to do when the user selects more then one.
    LVL 11

    Accepted Solution

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

    Expert Comment

    by:Simone B
    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,", ")

    Author Comment

    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.

    Author Closing Comment


    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    Written by Valentino Vranken. Introduction: In a previous article ( I announced that I would writ…
    Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
    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…
    This video discusses moving either the default database or any database to a new volume.

    755 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

    21 Experts available now in Live!

    Get 1:1 Help Now