I have used STPointFromText to calculate a geography point for each location on my map.

I have selected a bubble map top visualise a data field at each point.

This works fine.

However, is it possible to represent the areas in between these data points as colour also, like the following:

I will obviously need to calculate the value of the area between each data point so I can represent as a colour. 

Is this possible with SSRS? What is the calculation? Will I require another layer on top of the point layer?

Hi DarrenOD,

According to your description, you want to create a heat map to represent areas as color, right?

In your scenario, its possible to create a heat map with color specified in the corresponding size of rectangles. You can add additional map layer use Color Analytical Map in your report to show data region with different color. For more information, please refer to this article: Heat Maps for SSRS using Map Control.

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu