SSRS Tutorial: Part 5 - Embedded Datasets

This article explains the following,

• What is Datasets?
• What is Embedded Datasets?
• Create Embedded Datasets using Stored Procedure.
• Query Designer.

Dataset: Dataset represents report data that is returned from running a query on an external data source.

Embedded Datasets:

• Embedded datasets are specific to the single report.
• Embedded datasets cannot be used by multiple reports.
• Embedded datasets are useful when you want to create a query that has no other dependencies.

Create Shared Dataset (Using Stored procedure)

To create Embedded Datasets, go to Report Data and right click on Datasets and select Add Dataset.



The following wizard will appear, in that you can see the list shared datasets.



Provide your dataset Name.

Select Use a dataset embedded in my report.

Select Data source from dropdown list (or click on New to create new Data source)

Select Query type as Stored Procedure.

Next click on Query Designer.



Then you will see the following wizard and select the desired stored procedure and click on Edit as Text.



Click on [!] to run your procedure.



Define query parameters and click on Ok.



At this point we can see the following Output. Then click on OK.



Click on OK.



At this point the Embedded Dataset created. You can see it in Report Data.