Showing posts with label .Net Reports. Show all posts
Showing posts with label .Net Reports. Show all posts

Friday, October 10, 2008

Giving Background Dynamically for Cells in ASP.Net Report Control

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.

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)