You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.
Become a sharper developer and jumpstart your career.
$0
$
. 00
monthly
For Basic members:
$10
For Premium members:
This article explains how to create embedded Data Sources.
Before reading this article, I highly recommend reading the previous part of the series:
This article explains
Data Source
SSRS supports two types of data sources:
Embedded Data Source
Steps involved in creating Embedded Data Source in SSRS 2012 The Embedded data sources can only be used by the report in which it is embedded. Step 1: Create Project. Go to Start > All Programs > SQL Server 2012 > Microsoft SQL Server Data Tools Once SSDT (SQL Server Data Tools) is running, click New Project to create a new project. Select Report Server Project under Reporting Services and specify the name and location. Step 2: Add Report. Go to Solution Explorer - Right Click On Report, click on Add, then New Item. Select Report and give it a meaningful name. Step 3: Add Data Source. Go to Report Data (Ctrl + Alt + D) and right click on Data Sources and click on Add Data Source. Step 4: Provide Data Source properties. Provide name of your embedded data source. Select Embedded Connection radio button. Click on Edit. Step 5: Connection Properties. After clicking on Edit, we have to provide the following Connection Properties in the following wizard.
Click Ok and then you will see the connection as follows. Click Ok. That’s it. Embedded data source created at this point. Go to Report Data (Ctrl + Alt + D), there you can see the created data source. If you want to addone more data source then go to Report Data (Ctrl + Alt + D) and right click on Data Sources and click on Add Data Source and do the same as above.
SQL Server 2012 Functions Recipes