gvamsimba
asked on
SSRS 2005 Multiple Paramerters
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.Val ue, "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 ?
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.Val
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 ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.