How to apply filter at report side in ssrs 2008 R2

Question

I have a expression inside a tablix for one of my report column Cases Shipped like this =IIF(Fields!Current_Product.Value= "Match"," ",Sum(Fields!Cases_Shipped.Value)) This add the cases shipped value of same ditributor item code. After this statement i want to apply a filter on this column on the report .there is a textbox parameter in which a user enter the number like 10 and the column on report get filtered through this value.

How can i do this??

Answer 1

Sounds like you are looking to change the Column Group visibility. (You are using column groups, right?) If so, right click on a column group and you can set the visibility by formula. The formula can incorporate a Parameter.

=IIF(sum(Fields!Cases_Shipped.Value ) >= Parameters!CasesShipped.Value and (Fields!Stocked.Value = "" OR Fields!Stocked.Value = "Yes" OR Fields!Stocked.Value = "No"), false, true)