Creating reports and dashboards | Stimulsoft community forum

Posted: **Wed Nov 06, 2019 2:40 pm**

Hello,
I am using a list type variable in the report. I can filter the report while I wrote the variable.Contains() expression to DataBand Filters. I want to use this structure in data source query. I tried this solution but it didn't work.

viewtopic.php?t=55467

Thank you,

Posted: **Thu Nov 07, 2019 9:55 pm**

Hello,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.

Posted: **Tue Nov 12, 2019 8:08 am**

Hello,
Sorry for the late reply. I found something and I tried, it worked. This script part is in Edit Data Source.

{var1.Count == 0 ? "" :"where id in ("+var1.ToQueryString("'")+")"}

Thanks.

Posted: **Tue Nov 12, 2019 8:37 am**

Hello

Ok.
Please let us know if you need any additional help.

Thank you.

Creating reports and dashboards | Stimulsoft community forum

Using List Type Variable in query

Using List Type Variable in query

Re: Using List Type Variable in query

Re: Using List Type Variable in query

Re: Using List Type Variable in query