Display Country's name in Textbox

  • 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.

  • 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.

  • 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