How to create heat map on a table in SSRS?

Question

How can I create like this in SSRS? The color will change from red to green based on a value in a row (Underwriter). And all that in a group: Answer You can do this by right clicking on the individual cells and setting the fill colour based on an expression: In the Image below I've mistakingly put "==" where

Accepted Answer

You can do this by right clicking on the individual cells and setting the fill colour based on an expression:In the Image below I’ve mistakingly put “==” where it should be “=”To give you an example the following:was created using the following expressions for the ID30, ID60 and ID90 fields respectively:ID30:=IIF(Fields!ID30.Value>="0" And Fields!ID30.Value<="100" ,"#c6c626",IIF(Fields!ID30.Value>="100" And Fields!ID30.Value<="200" ,"#c6c627",IIF(Fields!ID30.Value>="200","#9e2424","red")))ID60:=IIF(Fields!ID60.Value>="0" And Fields!ID60.Value<="100" ,"#c6c626",IIF(Fields!ID60.Value>="100" And Fields!ID60.Value<="200" ,"#c6c627",IIF(Fields!ID60.Value>="200","#9e2424","red")))ID90:=IIF(Fields!ID90.Value>="0" And Fields!ID90.Value<="100" ,"#c6c626",IIF(Fields!ID90.Value>="100" And Fields!ID90.Value<="200" ,"#c6c627",IIF(Fields!ID90.Value>="200","#9e2424","red")))

Advertisement

Answer