SSRS Tutorial Part 119 - How to Create Map Reports in SSRS ( Map Gallery - Basic 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.

You will learn below items in this video

  1. What type of data we need to create Map Report- Prepare our data for Map Report
  2. Create SSRS Report from basic and create DataSet with Map fields
  3. Get familiar with Map Gallery and choose a Map Type
  4. Choose Map Visualization ( Basic Map in this video)
  5. Choose Color Theme and Data Visualization
  6. Use the Map layer to configure Data Layer
  7. Enable Tooltip for State Population Data by using Polygon Properties and play with other properties such as Font,Fill,Border,Shadow etc.
  8. Change background color of Map by using Map Viewport Properties
  9. Understand Polygon Color Rules
  10. Understand Center Points and Different Properties of Center Points


Sample 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 Reports in SSRS ( Map Gallery - Basic Map) - SQL Server Reporting Services(SSRS) Tutorial