Page 1 of 1

Multi Select Filter

Posted: Thu Aug 29, 2024 5:51 am
by brightsg
I am using the desktop report designer and want to add a filter that is a mutli select with an (all) option. I have created a variable and set the filter in the band. When I run the report the dropdown to filter appears as expected, but I can only filter on one option and (all) does not work. Can anyone advise how I make this work please?

Re: Multi Select Filter

Posted: Thu Aug 29, 2024 4:54 pm
by Lech Kulikowski
Hello,

You should use the following expression:
Variable.Contains(datasource.column)

Thank you.