Friday, October 10, 2008

Giving Visibility True / False for a Report Control Row or Column

Right click in the field(cell) and click expression and add Expression as
=iif(Parameters!oTotal.Value = Fields!RowCount.Value ,False,True)


Right click in the cell again and click Properties
Click visibility tab and add expression as
=iif(Max(Fields!RowCount.Value)=5,Fields!ActualSales.Value+Fields!TOTALSales.Value,0)