Accessing String List Variable

[robert.andrews]

Hi

I have created a String List variable that users will use to filter the returns of data. Is there a way I can use this with the SQL Select statement to do some server side limits as opposed to all client side (Currently using the databand filter)?

Is there a way to display the contents of this variable similar to ToQueryString() without the escaping?



Finally, when trying to map the items in the list via Items, it doesnt seem to work for any Data Sources, see below for an example.

[Lech Kulikowski]

Hello,

Please select DataSource property. When select Items it is possible to add only static values.

Thank you.

[robert.andrews]

Hello,

Please select DataSource property. When select Items it is possible to add only static values.

Thank you.

Thanks for that!

Is there a way to access the list of items in the variable with a simple CSV style output?

[Lech Kulikowski]

Hello,

Sorry, maybe we did not exactly understand your question. Could you explain your issue in more details?

Thank you.

[robert.andrews]

The options that a user may have selected within the List, is there a way to display those on the page as feedback to the user?

Using ToQueryString() on the variable name is close to what I need however it also applies some escaping to the values.

Thanks

[Lech Kulikowski]

Hello,

Unfortunately, only ToQueryString() method is available for the List Variables.

Thank you.

[ianwelsh]

This may or may not help:
due to how we've integrated this into our software, our "choose one or more" options are passed to the report as a single string variable, with the selected options comma delimited. The passed options would be ID values.

We then use the following in the WHERE clause:

@map_ids = '' OR CHARINDEX(','+CONVERT(VARCHAR,maps.id)+',',','+@map_ids+',')>0

Variable: map_ids ("Allow using as a SQL parameter" = true, string/value)
Database Table/Index: Maps / ID

Hope that makes sense and helps.

[HighAley]

Hello.

Thank you for your solution.