In this how-to article we will show you how to create a Map which will present the sales distribution by products among several states
using the Adventure Works sample database and the Standalone Report Designer.

Important

This article assumes that you have obtained a valid Location Provider key to authenticate your geocoding requests.
If you don't want to use a location provider, you need to provide the geographical coordinates of your points yourself and setup the MapSeries accordingly.
For more information please take a look at the Location Providers article.

Start the Map Wizard:

If you create a new report, select the Map Wizard icon from the Available Templates page.

If you want to add the Map item to an existing report, you have to select the Map item
from the Insert menu.
This will bring up the Map Wizard which will guide you through the creation process.

You can click on Execute Query... just to check if everything is OK with the database connection.
Click Finish when you are ready.

In the Available data sources list you should see the datasource you've already created.
Select it and click Next.

In the next page you have to select the fields which will be used to build the map charts.

Note

Since the map will use a Location Provider, there is no need to provide the Latitude and Longitude coordinates by yourself, so you can
left these boxes empty and just define a location group, which will set the geocoding string.

Select the Pie Chart radiobutton from the Datapoints type box.

Select the ProductSubCategory field and drag it to the Series (color) box.

Select the State field and drag it to Categories (location) box.

Select the LineTotal field and drag it to Size box, where it will be transformed to

Sum(LineTotal)

Your Arrange map fields page should look like the one shown below:

Once the mandatory fields are set up, the Next button will get enabled and you can go to the next page.

On the Choose a location provider page you have to select the location provider that will be used to geocode
the State field that was dragged in the Categories (location) box on the previous page.
Currently the supported providers are
MapQuestOpenAPILocationProvider
,
MapQuestLocationProvider
and
BingLocationProvider.
They both require a valid client token (key) to authenticate the geocoding requests that will be sent from the Map item.
Once you have obtained the key, you should paste it in the Client token box, as shown below:

When you click Finish, the Wizard will create the definition of the Map item, show it in the designer
and will start to request the geocode and tiles information from the providers asynchronously. Initially it will take a few seconds to fetch
all the data from the geocoding service, but the following requests should be executed faster. The tiles, needed to prepare the map background,
will be displayed as they arrive, but the map will stay responsive and you can examine and change its definition.
When finished, your map should look like this:

In this example we demonstrated how to setup a Map item from scratch, how to add PieChart series to it and how to initialize and
use the Location Provider. All the described steps are valid for both
Standalone Report Designer
and Visual Studio Report Designer and
can be reproduced with code as well.

Other Resources

Give article feedback

Tell us how we can improve this article

Code samples are inaccurate / outdated.
I expected to find other / more information.
There are typos / broken links / broken page elements.
Content is inaccurate / outdated.
Other
By checking this box you consent to Progress contacting you by email about your response on this page.