How to create report filter with checkbox list

[tausin]

Dear support

I have created report with sql postgre datasource and I need to create any userfriendly filter for users.

I am able to create filter with textbox ( picture 1) - I created new variable pnps_id and then I put it into select: where my_data_id = @pnps_id. It works OK

but I want to create filter with select list (picture 2). - I created new variable but when I change type of variable from VALUE to LIST, checkbox "Alow as SQL parameter" is disabled.

is there any solution, how to create filter with checkbox list (picture 2) ?

Thanks

[Lech Kulikowski]

Hello,

You can use the following query:
select * from Products where CategoryID in {(var1.Count == 0 ? "('')" : "(" + var1.ToQueryString("'") + ")")}

Thank you.

[tausin]

Hello,

You can use the following query:
select * from Products where CategoryID in {(var1.Count == 0 ? "('')" : "(" + var1.ToQueryString("'") + ")")}

Thank you.

Thank you, it works!

[Lech Kulikowski]

Hello,

You are welcome.