Hi - i need to create a 32 tile Heatmap in SSRS 2008 R2, does anyone know how to achive such a feat - I only started using it 2 days ago, so any help is much appreciated, I am not too concerned with adjusting colours by values, I just need to get the 32 tiles in place in the report initially, then extend it with more functionality later on. Please help me get started - I know this can be done using ascalar geospatial report.

 

 

Take a look at the following articles. You might find them useful.

http://theruntime.com/blogs/THOMASSWILLIAMS/archive/2007/05/04/reporting-services-heatmap.aspx

http://prologika.com/CS/blogs/blog/archive/2009/08/30/heat-maps-as-reports.aspx

 

Best Regards,

Datta

Hi rtdh,

Please refer these 2 articles for detail steps:
http://www.arrangeactassert.com/how-to-create-heat-maps-in-sql-server-reporting-services/
http://blogs.msdn.com/b/bobmeyers/archive/2009/07/31/add-excel-like-color-scale-conditional-formatting-to-your-reports.aspx

Regards,
Lola

TechNet Subscriber Support in forum
If you have any feedback on our support, please contact tnmff@microsoft.com.

Thanks very much for your help everyone, client decided to represent the data using a bubble/scatter graph rathe rthan a heat map but this info is v. useful.

 

If you submit answers i will accept both...

The first article is very helpful and informative. However, in the section for the expression to fill, it uses the whole "dataset1". Anyone know how to limit it to say a group by. I have tried scope and group by variable but cant get the correct syntax. I have a region and within it there are several stores. Each store is its own group. I want to apply the heatmap to each store instead of at the dataset level.