I have an SSRS combo box that will pass 1 of 3 values to my stored proc.
I need the report to do the following based on one of these 3 options being picked.
If the parameter Native is picked...then it should be be equal to the columns value in the report of Native.
the same if Linked is chosen..
If All is chosen it should return anything in this column...which could be "Native" , "Linked", '' , NULL
Please help me build the where clause to handle this.
Here is what I have ..but its not working.
(((@NativeLinked = 'Native' or @NativeLinked= 'Linked') and t2.[Native/Linked] = @NativeLinked) or ((@NativeLinked = 'All') and t2.[Native/Linked] is null or @NativeLinked = 'Native' or @NativeLinked= 'Linked'))