Hi... I am trying to display a parameter in my report.. the parameter can have up to 5 chocies... if all 5 are checked I want to display all 5..
I know how to trick it and use: Parameters!Country.Value(0)&Parameters!Country.Value(1) etc
Is there a way to do this that I dont have to have from (0) to (5)..
another thing... when you only choose 2 of the 5 params the rest show errors.. (#Error)
Thanks for help... and Happy Reporting !!
Hey....I'm trying to do the same thing. So far, the best I've come up with is:
join(Parameters!Country.Value, Chr(13) & Chr(10))
This will create a string with a CRLF between all the parameters. Of course, you can change the delimeter to anything you want, but I'm still working on a way to A) insert tabs and B) stick my multi-value parameter in a table or list, but so far, no luck. So if you've got any idea...
No comments:
Post a Comment