Pro SQL Server 2012 Reporting Services

(sharon) #1

CHAPTER 5  IMPLEMENTING DASHBOARD STYLE REPORT OBJECTS


Figure 5-13. New Map Layer Wizard: Choose map visualization options

Select the middle visualization Color Analytical Map and click Next. On the Choose the analytical
dataset screen, you need to select or create a dataset which includes the spatial data. You are going to
use the existing dataset, so choose the Emp_Svc_Cost_By_Patient_State dataset and click Next to
proceed. On the Specify the match fields for spatial and analytical data screen, you need to select which
fields in your dataset match with Map Gallery that you selected. In this case, the wizard realized that you
had a StateName field and automatically creates a link to it, as shown in Figure 5-14. If you didn’t have
StateName but you had the state abbreviation, you would need to specify what field in your dataset
would match. In that case, you could match your State column to the STUSPS spatial data column. Be
sure that the Match Fields has the checkbox next to STATENAME and the Analytical Dataset Fields is set
to StateName and click Next to proceed to the Choose color theme and data visualization screen.
Free download pdf