Knight's Microsoft® Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server® Integration, Analysis, and Reporting Services with Excel® and SharePoint®

234



LESSON 26 Using Maps in YoUr report

FIGURE 267

FIGURE 268

889633c26.indd 234 8/16/10 9:12:31 PM

Using Maps in YoUr report



235

The last window of the Map Wizard has some of the same options discussed in the earlier examples.

Now you can select TotalDue as the data field to represent on the map. The sizes of the bubbles and

the colors of the bubbles can be used to show the value of the data. You can also use both to show

the values if you desire. Figure 26-9 shows this map with the size used to indicate the TotalDue data.

Notice how the roads can make it difficult to see the data on the map. This should be taken into con-

sideration when you are creating maps for reporting. If your end users have a hard time seeing the

data, then the map becomes useless to them.

FIGURE 269

Now that you have created a map, you will need to know how to adjust the

map in the future without running through the entire wizard again. You can

do this with the map control on the right-hand side of the map in design view.

Figure 26-10 shows this control and the following list explains each item.

1. New Layer Wizard: Starts the wizard and will add a new layer of

data to the map

2. Add Layer: A drop-down menu that adds a new data layer to the map

3. Visibility: Sets the layer to be visible or hidden ...