faizan ahmad

Quite Straight forward:

1. Select the Column , Right Click -> Propoerties OR hit F4
2. Visibility -> Hidden -> Expression i.e. Click on Hidden under Visibility and select Expression from Drop Down
3. Write the expression e,g.

=IIF(Parameters!MonthlyOrYearly.Value.Equals("Monthly"),false,true)

compared to FormatDateTime Good old 'Format' function makes the job a lot easier :

1.  Format(Fields!ResultDate.Value,"M/d/yyyy")
2. Format(Fields!ResultDate.Value,"yyyy")

=IIF(Parameters!MonthlyOrYearly.Value.Equals(Monthly"),Format(Fields!ResultDate.Value,"M/d/yyyy"),Format(Fields!ResultDate.Value,"yyyy"))