What is the difference between spatial data and analytical data?.Specify a data source for the analytical data. Build a query that specifies the analytical data.Ĭhoose the analytical dataset. Choose a data source connection or create one to an external data source that contains analytical data to display on the map.ĭesign a query. What is the difference between a Basic Map, a Bubble Map, and an Analytical Map?Ĭhoose a connection to a data source Choose map visualization: Points. Set the map view, the map resolution, specify whether to embed spatial data in the report, and specify whether to include a tile background of Microsoft Bing map tiles.Ĭhoose map visualization. (ESRI) Shapefile, or from spatial data in a SQL Server relational database.Ĭhoose spatial data and map view options.

Spatial data can come from the map gallery, an Environmental Systems Research Institute, Inc. The pages that you see vary depending on your choices for the type of map, the source of spatial data, and the source of analytical data.Ĭhoose a source of spatial data.

Click the map to display the Map pane and on the toolbar, click the New layer wizard button.Ĭlick the title of the wizard page for the corresponding help content.

To open the Map Layer wizard, do the following action: On the Insert tab, click Map, and then click Map Wizard. When you first open Report Builder, click the Map wizard icon in the center of the design surface. The following sections provide information about options that you specify when in the Map and Map Layer Wizards. Match fields that define the relationship between spatial data and analytical data, for example, the name of a region and city to uniquely identify each city. Analytical data to use to vary the map display, for example, annual store sales.

From the spatial data source, a field that contains sets of coordinates that specify locations.Īnalytical data. The location or connection to a source that provides spatial data, for example, the name of a SQL Server instance and a database that contains spatial data, or the name of an Environmental Systems Research Institute, Inc. In Reporting Services paginated reports, the Map Wizard and Map Layer Wizard automate the task of creating a map, adding a map layer, or changing map layer options on an existing layer.īefore you add a map to a report or a map layer to a map, gather the following information:

Microsoft service map designer