November 6, 2013 at 2:32 pm
Goal:
Display the name of countries in a list based on selection. For instance, if I select Australia and France, the country's name should display in the textbox. If I select (Select All), all the country's name shall be printed in the textbox.
Problem:
I do not know how to do it. I can retrieve one country but not many countries.
November 6, 2013 at 5:18 pm
You can use the Join function in an expression to create a delimited list.
E.g.
=Join(Parameters!Country.Value,",")
Would create a CSV string of the selected countries.
November 14, 2013 at 9:40 am
Get me? (11/6/2013)
You can use the Join function in an expression to create a delimited list.E.g.
=Join(Parameters!Country.Value,",")
Would create a CSV string of the selected countries.
i agree with this solution. usually i accomplish this kind of thing on the database side using a UDF, but it's the same principal. one thing i must allow for is datatype size. the datatype may be set up to allow for 50 characters (thinking that a single country's character count isn't likely to go above 50 characters) - however, when you are using a deliminated value, you have to think about how many characters ALL the country values will have. if you don't allow for this you will likely get a truncation error.
Dana
"Drats! Foiled again!"Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply