Sunday, March 11, 2012

displaying Params in Report

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