SSRS Tutorial Part 119.1 - How to create Map Report in SSRS ( Map Gallery - Color Analytical Map)

In this video of SSRS Tutorial, we will learn how to create Map report in SQL Server Reporting Services by using Map Gallery which use spatial data from a set of installed maps. The Map layer we will use in this Report will be Color Analytical Map.

You will learn below items in this video
How to create Map report by using Map Gallery with Color Analytical Map map layer
How to map the Spatial and Analytical Data in Map Wizard
Choose the Theme,Field to Visualize,Color Rule and Display Label
How to customize Polygon Layer
How to Change Label Text and Tooptip for Map
How to enable Center Points and customize them

Sample State Population Data

CREATE TABLE [dbo].[StatePopulation](
 [StateName] [varchar](50) NULL,
 [Population] [int] NULL,
 [year] [int] NULL
) 

GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Alabama', 4785822, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Alaska', 713856, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Arizona', 6411999, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Arkansas', 2922297, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'California', 37336011, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Colorado', 5048575, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Connecticut', 3579345, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Delaware', 899731, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'District of Columbia', 605210, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Florida', 18852220, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Georgia', 9714464, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Hawaii', 1363950, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Idaho', 1570639, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Illinois', 12840097, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Indiana', 6490308, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Iowa', 3050295, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Kansas', 2858949, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Kentucky', 4349838, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Louisiana', 4545581, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Maine', 1327361, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Maryland', 5788101, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Massachusetts', 6564073, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Michigan', 9876498, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Minnesota', 5310418, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Mississippi', 2970811, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Missouri', 5996085, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Montana', 990575, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Nebraska', 1829865, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Nevada', 2703493, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'New Hampshire', 1316517, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'New Jersey', 8803580, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'New Mexico', 2064950, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'New York', 19400867, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'North Carolina', 9559488, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'North Dakota', 674345, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Ohio', 11540070, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Oklahoma', 3759481, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Oregon', 3837083, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Pennsylvania', 12711077, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Rhode Island', 1053078, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'South Carolina', 4636290, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'South Dakota', 816192, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Tennessee', 6356628, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Texas', 25245717, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Utah', 2774346, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Vermont', 625792, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Virginia', 8025376, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Washington', 6741911, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'West Virginia', 1854176, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Wisconsin', 5689268, 2010)
GO
INSERT [dbo].[StatePopulation] ([StateName], [Population], [year]) VALUES (N'Wyoming', 564358, 2010)
GO



How to create Map Report in SSRS ( Map Gallery - Color Analytical Map) - SQL Server Reporting Services(SSRS) Tutorial




No comments:

Post a Comment