Skip to Content

Heat Map of Zip Codes in a city...

Jan 30 at 05:35 PM


avatar image

I am trying to create a Heat Map or dot density map in Crystal Reports for a particular city in CO. I have looked at 3 mapping software applications and none of them seem to have the "layers" I've heard about having to use in Crystal Reports.

Would someone please tell me a valid way to get layers in Crystal and a link to instructions on how to set them up?

I'd really appreciate it.

Thank you,


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Nitzan Neeman Jan 30 at 11:59 PM

Hi Erin,

I was able to accomplish this by using several tools.

First, you would need to visit Google's Geo-coding site in order to register your project and obtain an API key (Free).

The URL is

Once you have your key, you will need to draft a Crystal Report while embedding the base HTML code that is available on Google's site as a reference.

Basically, the HTML code will be split between the Crystal Report's header and footer, where the actual Geo-coding details will be retrieved in the details section of the report.

In my case, since my maps are dynamic and rely on information saved in SQL, I am using a great tool called "Cut Light" from Millet Software that enables me to obtain Lat Long coordinates based on an address, should these values be missing from the database.

I am actually using another utility from Millet Software called "Visual Cut" to dynamically extract updated information from the database and publish this heat map for local users to view (This utility has tremendous capabilities and I highly recommend it for all of your automated bursting reporting needs)..

I am attaching a sample screen shot from the end result.

If you would like to follow this process and implement it with your data, feel free to email me at and I will be happy to assist you any way I can.



heatmap-sample.png (379.4 kB)
10 |10000 characters needed characters left characters exceeded
Vitaly Izmaylov
Jan 30 at 06:15 PM

The Map functionality was added in ealiest versions of Crystal Reports (like CR 7) and was not really improved/developped since. It looks like it was very expensive to add a new layout. See the following article:

10 |10000 characters needed characters left characters exceeded