CODEWITHSUNDEEP
reporting-servicesssrs-2012ssrs-2014
DooDoo
DooDoo

Reputation: 13447

How to Create Embedded Data Source in SSRS 2014

I want to create embedded data source in SSRS 2014 using Visual studio 2013. But there is no item for embedded data source. How I can add it?

enter image description here

enter image description here

Thanks

Upvotes: 0

Views: 141

Answers (1)

R. Richards
R. Richards

Reputation: 25151

You create an Embedded Data Source in the report itself, not in the project.

Create a new report in your project (or use an existing one). Then, in the Report Data pane Ctrl+Alt+D, create a new Data Source by right-clicking on the Data Sources folder.

Choose Embedded connection, the Type and populate the Connection String with the settings that are appropriate for connecting to your database.

Afterward, add a new dataset by right-clicking on the Datasets folder and choosing Add dataset. Choose Use a dataset embedded in my report, and pick the data source you created above.

The report will use that embedded connection going forward, at least for this dataset.

Upvotes: 1

Related Questions