Unfortunately I did not find any ideal solution to this issue, however I will present here a (somewhat) acceptable solution, that allows the user to tweak zoom level while automatically centering on the locations of interest.
To start, I created a basic report that displays the world map, and visualizes country data from the AdventureWorksDW by color. For simplicity, I removed the legend and color scale, and this is what I have:
|Figure 1 - Starting map|
What we will do is allow the user to specify the countries of interest, and the map automatically centers itself between those countries.
I modify my data set to take a list of countries as a parameter, and then add the list of countries as a report parameter.
|Figure 2 - Countries parameter|
The next step is to enable the automatic-centering between the countries of interest. To show you what I mean, I (for now) manually zoomed into the map and then with the report running, I selected only Australia. Figure 3 shows the result.
|Figure 3 - Map automatically centers on Australia|
|Figure 4 - Center map|
|Figure 5 - ZoomLevel parameter|
I called the parameter ZoomLevel, and now the viewport properties looks like Figure 6.
|Figure 6 - Map zoom level from parameter|
|Figure 7 - Map centered and zoomed|
tags: reporting services report builder 3.0 maps dynamic zoom automatic