SSRS 2005 Multiple Paramerters

Posted on 2009-02-19
Last Modified: 2012-05-06
Hi, I have three parameters like this on my SSRS 2005 Report.

where  brokerno  in (@brokerno)
and class IN(@class)
and  schemet IN (@schemet)

           the second and third are cascasding paramerters, i.e they are dependent on the brokerno. In my layout , i have a texbox at the top displaying the brokerno which the user enters in the brokerno parameter. The expression in the textbox is =First(Fields!Brokerno.Value, "VKtest")

        Now my question is, when a user selects multiple brokers in the broker parameter, the text box value is only showing the first broker in the order and not the others.. IS there anyway to re-write my expression so that the users can see all the brokers in that text box value as they select in the parameter box ?

Question by:gvamsimba
    1 Comment
    LVL 21

    Accepted Solution


    Sure there is, but you have to use your parameter, not a field:

    =Join( Parameters!Brokerno.Value, ", " )

    If you have Value and Label different, you may want to use Label instead.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
    Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    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

    10 Experts available now in Live!

    Get 1:1 Help Now