Right Click in the cell and click Properties. Click on the Background color in the Property box and click expression in the dropdown box for selecting the background color.
=iif(Parameters!oTotal.Value = Fields!RowCount.Value ,"YellowGreen","White")
If Row Count and Total are equal, Background color would be YellowGreen, else White.
Showing posts with label .Net Reports. Show all posts
Showing posts with label .Net Reports. Show all posts
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)
=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)
Subscribe to:
Posts (Atom)