Stimulsoft Business Intelligence System | Forum

Hello,

i have a rather simple form which contains a checked list box (name: licenses) and I want to store the selected values into a variable (Name: abc) upon click on "OK" Button in order to use the selected values in a SQL query.
How do I do that?

Hello,

The Form is obsolete. You can use the Request From User option for the variable, and then use this variable in the query.

Thank you.

Do you have some kind of example for the "Request From User option" or a "how to" so to say?

Hello,

Parameters category on our Demo:
https://demo.stimulsoft.com/#Net/Parame ... Categories

Thank you.

Ok, understood.
If i want to use the selected Values as paramter in my query it says "Cannot convert StringList to string"

Can it be worked around with an expression for example?

Hello,

In this case, you should use the ToQueryString() for the list variable.

Thank you.

If I use your example in my SQL-Query (of course with correct var-reference) results in Parse error: Syntax error

Concerning bit of SQL-Query: AND L.SkuPartNumber IN {(us_lic.Count == 0 ? "('')" : "(" + us_lic.ToQueryString("'") + ")")}

Hello,

If the SkuPartNumber is numeric, please try to check:
IN {(us_lic.Count == 0 ? "(0)" : "(" + us_lic.ToQueryString() + ")")}

Thank you.

Nope, it's a string

Hello,

Please send us a sample report with test data for analysis.

Thank you.