Warm up your users this winter with heat maps in SQL Server 2005:
This report was created by one of our testing gurus, Patrice Brassard, and uses a to show up a dll he has written in c#. The code was used to simplify the process of applying conditional formatting in every cell of the report.
The DLL contains a static public method:
public static string GetColor(decimal redStartVal, decimal yellowStartVal, decimal greenStartVal, decimal val)
The function returns a string corresponding to the Hex value of the colour.
The example report above represents test results so Patrice wanted only 100.00% to be shown green (i.e.99.99% should be yellow) so he used the following values:
WLX_SSRS_Utils.HeatMap.GetColor(70.0, 99.99, 100.00, (Sum(Fields!RawPass.Value) / (Sum(Fields!RawPass.Value) + Sum(Fields!RawFail.Value) + Sum(Fields!RawNotRun.Value))) * 100.0)).
Please note that the attached DLL that needs to be on both your dev machine and the SSRS server:
Segnalo l'interessante post di Andrew Fryer sulla possibilità di colorare le celle di un report in
I've also done a blog post on how to create Heat maps in SQL Server Reporting Services. I developed an Excel export friendly solution.