Change background color of a cell based on value from previous details value?

There is the Previous function that allows you to access the field values of the previous row. So in the cell for the second column you could write an expression like the following for the BackgroundColor property.

Up vote 1 down vote favorite share g+ share fb share tw.

I have a custom report that shows some numbers in the form of a simple table report. The problem is changing the background color of a cell based on previous data. Consider this image: I want to change the background color of the cell with value 156 into red because in the previous record in the third column I have a value lower than 100.

How I can do this with SQL Server reporting service? Sql-server-2008 reporting-services ssrs-2008 ssrs-reports link|improve this question edited Jan 28 at 13:36NGLN10.3k21138 asked Jan 28 at 12:45Kerezo2,430219 89% accept rate.

There is the Previous function that allows you to access the field values of the previous row. So in the cell for the second column you could write an expression like the following for the BackgroundColor property: =IIF(Fields!SecondColumn. Value > Previous(Fields!ThirdColumn.

Value), "Red", "Transparent").

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.