SSRS 2005 Multiple Paramerters

Posted on 2009-02-19
Medium Priority
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

Yurich earned 2000 total points
ID: 23685540

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.


Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

830 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