SSRS Tutorial Part 131-Setup Windows file share subscription in ssrs with Default Parameter Value

In this video of SSRS Tutorial, You will learn how to Setup Windows file share subscription in SSRS with Default Parameter Value( Single Value and Multi Value)

You will learn
  1. How to use Report Manager to setup Windows File Share Subscription in SSRS With Default Parameter for Single Value Parameter
  2. Change the Parameter to Multi Value and redeploy to Reporting Server and configure File Share Subscription for Multiple Values for a parameter
  3. How to execute SQL Server Agent Job after creating Subscription to verify if everything working fine
  4. Understand and solve Common Errors while creating SSRS subscription



Setup Windows file share subscription in ssrs with Default Parameter Value - SQL Server Reporting Services (SSRS) Tutorial
1 comment:

SSRS Tutorial Part 59.1 - How to use External Image in SSRS Report

In this video of SSRS Tutorial, we will learn How to use External Image in SSRS Report.

You will learn
  1. How to create Basic Report and use Image files from Local path
  2. How to use UNC Path for Image Files and display in SSRS Report
  3. How to use image from website and display in SSRS Report

from local drive
file:\C:\Users\ashahzad\Desktop\TB\logo.gif

from UNC path
file:\\\\ComputerName\\c$\\Users\\ashahzad\\Desktop\\TB\\logo.gif

from Website
http:\\mywebsite.com/folder/logo.gif


How to use External Image in SSRS Report- SQL Server Reporting Services(SSRS) Tutorial
1 comment:

SSRS Tutorial Part 119.5- How to create Map Reports in SSRS (SQL Server Spatial Query)

In this video of SSRS Tutorial, we are going to create the Map report from SQL Server Spatial Data. We will be using Map Template  for SQL Server Spatial Query.

We will do below items in this video
  1. How to Add Geography column to existing Table
  2. How to upload .shp file to SQL Server Table
  3. How to update Geography column in one table from other table
  4. Create Map in SSRS by using SQL Server Spatial Query from Actual Data
  5. How to Join two tables for Spatial Data so can display all the Countries instead of only which has the data
  6. How to Custom Color the Countries which has data
  7. How to use Tooltip to display Country Name on hover
  8. How to display actual data on Map
  9. Understand Why label data does not appear on map and how to display it in any conditions


Credit Goes to
http://thematicmapping.org/downloads/world_borders.php for shapefile
Use this dataset with care, as several of the borders are disputed.


For Shap2sql software, credit goes to
http://www.sharpgis.net/page/SQL-Server-2008-Spatial-Tools


How to create Map Reports in SSRS from SQL Server Spatial DataSet- SQL Server Reporting Services(SSRS) Tutorial
2 comments:

SSRS Tutorial Part 119.4 - How to create Map Reports in SSRS (Shapefile and Bing Map Layer)

In this video of SSRS Tutorial, you will learn  How to create Map Reports in SSRS (Shapefile and Bing Map Layer)

In this demo you will learn below items as well.
  1. How to use ESRI shapefile for SSRS Report
  2. How to create Map Report from Scratch in SQL Server Reporting Service
  3. How to use Map Templates in SSRS Report to create Map Reports quickly
  4. How to join Spatial Dataset to Analytical Dataset in SSRS for Map Report
  5. How to change Polygon Color Rule to show different colors on Maps
  6. How to write expressions and Tooltip for Map Report in SSRS
  7. How to use Bing Maps Layers with ESRI Shapefile 



Credit Goes to
http://thematicmapping.org/downloads/world_borders.php for shapefile
Use this dataset with care, as several of the borders are disputed.




How to create Map Reports in SSRS (Shapefile and Bing Map Layer) - SQL Server Reporting Services(SSRS) Tutorial

No comments:

SSRS Tutorial Part 119.3 - How to create Map Reports in SSRS ( ESRI Shapefile)

In this video of SSRS Tutorial, we are going to learn How to create map reports. We have data for different countries and we would like to display on world map.

You will learn below items in this video

  1. How to download ESRI Shapefil for world map as SSRS Does not have builtin Map for World Map
  2. How to use Map Wizard to Map Spatial DataSet to Analytical Data set Fields
  3. How to display Country Name or Country Abbreviation(ISO3) Code on Map
  4. How to Hide names for all the countries where we don't have data
  5. How to set Tooltip for Country Name and Data Value
  6. Play with ViewPort Properties to change the projection


Credit Goes to
http://thematicmapping.org/downloads/world_borders.php for shapefile
Use this dataset with care, as several of the borders are disputed.
How to use ESRI shapefile to create Map Reports in SSRS- SQL Server Reporting Services(SSRS) Tutorial
No comments:

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
No comments:

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:

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



1 comment:

SSRS Tutorial Part 130-Create SSRS Report with DateTime By Using Standard Subscription In SQL Server Reporting Services

In this video of SSRS Tutorial, we are going to learn how to Export Report to a folder by using Standard subscription. As we would be exporting the SSRS Report we would like to add datetime to it.

In this video you will learn

  1. How to create standard subscription for SSRS Report to export report in folder
  2. How to add Datetime to Report and export by using Subscription in SSRS


How to Export SSRS Report with Datetime suffix by SSRS Standard Subscription  - SQL Server Reporting Services(SSRS) Tutorial
No comments:

SSRS Tutorial Part 129- How to Setup a Windows File Share Subscription in SSRS

In this video of SSRS Tutorial, We will learn How to setup File Share Subscription in SSRS.

You will learn below items in this video
  1. How to setup File Share Subscription from Basic
  2. How to check the Subscription record in dbo.Subscription Table in ReportServer Database
  3. How to create schedule for Report Subscription
  4. How to run Subscription from SQL Server Agent Job on Demand


How to configure Windows File Share Subscription for SSRS Report - SQL Server Reporting Services (Tutorial)
No comments:

SSRS Tutorial Part 128 - Reporting Services Databases ( ReportServer and ReportServerTempDB)

In this video of SSRS Tutorial, we will learn about ReportServer and ReportServerTempDB.

We will learn below items in this video

ReportServer Database:

ReportServer is the database which is used to store Metadata and Definition of Objects used by Reporting Server.

ReportServer TempDB:

ReportServerTemp DB is created with ReportServer Database.It stores temporary data, session information, and cached reports.


ReportServer Database Objects:

dbo.Catalog:

This table contains information related to Home,Folders,Sub Folders, Reports,Data Sets,Data Sources, Report Definition(XML) as content column

Select * from dbo.Catalog

Dbo.DataSource:

This table stored all the Data Sources embedded or shared.

  Select * From dbo.DataSource

Dbo.DataSets:

It stores list of shared data sets.

Select * From dbo.DataSet

Dbo.Subscription:

This table stored the information related to Subscription such as Description,LastStatus,EventType,Parameters and deliveryExtension

Select * From dbo.Subscription


Dbo.Schedule:

This table contains information for schedules on which the subscriptions are scheduled.


Introduction to SSRS Databases ( ReportServer and ReportServerTempDB) - SQL Server Reporting Services (SSRS) Tutorial



No comments:

SSRS Tutorial Part 127- Export Report Items ( Tablix,Matrix,Chart) to Different Sheets in Excel with Names

In this video of SSRS Tutorial, we are going to learn How to export different Report Items such as Tablix, Chart and Matrix to different Sheets. We would also like to have uniqure name for each sheet instead of Sheet1,Sheet2 etc.

You will learn below items in this video

  1. How to Export all items on Single Sheets in Excel from SSRS
  2. How to introduce page break for each of the item ( tablix, Matrix and chart etc.) and export to Excel and see the ourput
  3. Set the PageName property for each items to rename Sheets as required and Export to Excel file to see the output


How to export different Report Items to Excel sheets with custom Names - SQL Server Reporting Services(SSRS) Tutorial
No comments:
Subscribe to: Posts (Atom)