Ok yet another problem here. I have a report that I am building and for various reasons I need to filter it in place based on parameters vs passing parameter values directly to a SQL. The set up is as follows. I have a multivalue parameter (Serial number) that gets it's values from a select statement from a dataset based on a table lets call the table "parameter list" I have a report dataset that is built on a myriad of tables and nested select statements that I'm realy trying to keep simple stupid. That report dataset contains a field called "serial number" So in simplest form I have no problems creating an SSRS filter with an in operator to filter down on multiple values. Here is the problem. The main report dataset has records where that "serial number" field is null. So what I really need to do is to create an OR filter that will pull all the numbers selected from list available plus null values. I tried to build an expression with orElse but problem is that in expression builder there is no IN operator to accomodate multivalues. Any thoughts?

Hi matrosov, The OR gets only enabled if the filter expressions of two filters are identical. Note: another option is to use OR directly in your filter expression. Example: Filter expression: =(condition1 OR condition2) Filter type: = Filter value: =True Please let us know your feedback. Thanks KumarKG, MCTS

Kumar my problem is that it is a multivalue filter meaning I need to somehow replicate an IN statement in the expression. Meaning filter expression:=in(condition1,condition2,.......condition10) or condition 11.