How to write SSRS filter expression for channel in (CASE @channel WHEN 'ALL' THEN channel ELSE @channel END)

You may be after a Switch statement =Switch(a=1,"result 1" , a=2, "result 2" , a =3, "result 3")

Hi Rams4173, Reporting Services provides IIF() and Switch() decision functions for us to write an expression. We can also add a parameter to a report to filter data, vary appearance, and connect to related reports. I suggest you refer to the following articles, please see: Expression Examples: http://msdn.microsoft.com/en-us/library/ms157328.aspx Adding Parameters to Your Report: http://msdn.microsoft.com/en-us/library/ms155917(v=sql.100).aspx Filter Equation Examples: http://msdn.microsoft.com/en-us/library/cc627464.aspx If you have any more questions, please feel free to ask. Regards, Bin LongBin Long TechNet Community Support

Hi Rams4173, Reporting Services provides IIF() and Switch() decision functions for us to write an expression. We can also add a parameter to a report to filter data, vary appearance, and connect to related reports. I suggest you refer to the following articles, please see: Expression Examples: http://msdn.microsoft.com/en-us/library/ms157328.aspx Adding Parameters to Your Report: http://msdn.microsoft.com/en-us/library/ms155917(v=sql.100).aspx Filter Equation Examples: http://msdn.microsoft.com/en-us/library/cc627464.aspx If you have any more questions, please feel free to ask. Regards, Bin LongBin Long TechNet Community Support