I am trying to add a shared data source and data set to an SSRS project in SSDT/Visual Studio, also called Report Designer. There are plenty of ways to add this into a Report Builder. I am looking on how to do it in Report Designer.
They are published to http://local//report/dataset.
Thank you in advance for your help.
Best Answer
Here is an explanation retrieved from various MSDN and TechNet articles.
Prerequisites are
To import an existing data source in Report Designer
Adding Report Data
In Report Builder or Report Designer, you can add data in the following ways.
A detailed explanation can be found here: Report Embedded Datasets and Shared Datasets (Report Builder and SSRS)
There are some limitation in Report Designer:
List of references: