SSRS 2005 Multiple Paramerters
Posted on 2009-02-19
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 ?