SSRS Tutorial 03 - Understanding Shared Data Sources in SQL Server Reporting Services

In this video you will learn

What are Shared Data Sources? and why do we need to have Shared Data Sources?

Create SSRS Project/Solution

Create Shared Data Source

How to use Shared Data Source in Reports

How to Create Embedded Data Source and Convert to Shared Data Source

How to deploy Shared Data Source to Report Server

Step by Step SSRS Tutorial by Tech Brothers

[nirmalkumar]

Reading Text books is gud watching videos & learning them is
Great

NEED YOUR HELPING HANDS IN FOR IT SIR

[shivyogi]

You are helping community (tech) big time..

[krismaly]

Enjoyed watching this video.Narrator explains


Thanks a lot

[krismaly]

Enjoyed watching this video.Narrator explains
How to create Shared Data source
How to create Report
How to create Data Source for the report from Shared Data Source
How to create embedded Data Set
Why Shared Data Source and Why Embedded Data Source with a hint

If you don't see the "Report Data" Window then go to Menu and choose  "Report Data" menu

Aamir where is the link for Customer, Employee, Sales, SalesPerson, SalesPersonHistory data tables scripts?

Explains what is the purpose of Shared Data Source

Deployment was fun with SalesRegion and SaleRegion

Explained well about converting Embedded data source to Shared data source.

Thanks a lot

[satellitepop]

I love your videos, ,, Congratulations for you excellent work ....

[okeyokafor]

It would have been helpful for you to provide the SQL script to create the database and tables used in this video.

[mukulbiswas]

Where did you get reporting server?? please Give little explain about reporting server. Thank you .

[somias]

How can I dynamically pass the database instance and database name from the parameters of SSRS reports to external Data source

[singam]

Hi, Good one, can you upload some videos about dashboards by ssrs 2012, Thnx

[venkychepuri]

Hi Tech Brothers, while opening the URL for Reporting Services (for deploying the solution in to the Sql Server Reporting Services) its asking user name and password for Login to the web url .how to find my username and password ?

[arunpandey]

Hello sir..i am getting error while deploying the report to dba.."
Unable to connect remoteserver..URL is not correct.

[okeyokafor]

--Create Sample Table for view
CREATE TABLE dbo.Employee
(id INT IDENTITY(1, 1),
FName VARCHAR(50),
LName VARCHAR(50))
GO
--Insert records in SQL Server Table
INSERT INTO dbo.Employee VALUES('Aamir', 'Shahzad')
GO
INSERT INTO dbo.Employee VALUES ('Bob', 'Ladson')
GO