Monday, 21 May 2012

How to Build a Map Report - SQL Report Builder 2012


The objective of today's tutorial will be to use Report Builder 2012 Map Wizard to create a Map Report.


SQL Report Builder 2012  
Adventure Works 2012

STEP 1 - Create a Map

 Open Report Builder and Select the Map Wizard

 Next we have to choose our Spatial Data. We have three options for adding SD to our report. 

  1. Map Gallery
  2. ESRI Shape File
  3. SQL Spatial Query

Spatial Data 

Spatial data or geographic information  is the data or information that identifies the geographic location of features and boundaries on Earth. In a map, spatial data defines map elements: polygons that define areas or shapes, lines that define routes or paths, and points that define markers or pushpins. Spatial data is usually stored  in a binary format as coordinates. For example, a point is an X and Y coordinate (X Y), a line is two sets of coordinates ((X1 Y1), (X2 Y2)), a polygon is four or more sets of coordinates where the first and last set of coordinates are the same ((X1 Y1), (X2 Y2), (X3 Y3), (X1 Y1)). 

 Select map Gallery and continue by selecting the map of the State of New York.

Next we will except the defaults for Choose View Options. For Map Visualizations select Basic Map and continue.

A Basic Map displays locations only. You can vary the colors, but the color does not represent analytical data values.

A Bubble Map conveys the relative value for a single analytical data aggregate as bubble size,

An Analytical Map conveys the relative value of one or more analytical data aggregates for each map element.


1. Select Single Color Map
2. In Labels select #COUNTYNAME



No comments:

Post a Comment