SSRS Tutorial Part 119.2 - How to Create Map Reports in SSRS ( Map Gallery - Bubble Map)

In this video of SSRS Tutorial, we will learn how to create Bubble Map report by using Map Wizard in SQL Server Reporting Services.

You will learn

  1. How to Create Bubble Map Report by using Map Wizard
  2. How to modify Bubble Markers
  3. How to change Size of Bubble Markers



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