Home  >  Blog  >   SSRS

SSRS – How to Create a Report With a Shared Data Source

Rating: 4
  
 
4562

Creating a Report With a Shared Data Source

You now have a Shared Data Source in your project, but no dataset or report to display any information. Remember that a dataset will usually be specific to a report, so it’s easiest to create the dataset right after you create the report.

Reports are created inside a project, which is in turn inside a solution. If you only have one project, the solution might not be shown in the Solution Explorer. If you want to always see the solution, in SSDT go to the menu bar and choose Tools > Options. In the window that opens, find Projects and Solutions > General, and select Always show the solution.

Learn how to use SSRS, from beginner basics to advanced techniques, with online video tutorials taught by industry experts. Enroll for Free SSRS Training Demo!

When you create reports inside your project, SSDT offers the Report Wizard which can automate some of the steps, and also the manual way of creating a report. In this tutorial, we will not be using the Report Wizard, so reports will be created by right-clicking on the Reports folder and choosing Add > New Item. If you accidentally choose Add New Report and open the Report Wizard, just click Cancel to close it.

When a report is created or opened, a Report Data pane opens on the left side of the screen. This panel is concerned with the currently open report, whereas if you make changes in the Solution Explorer, you could affect all the reports in your project. One of the first things you will do in the Report Data panel is to set up a reference to the project data source. Then you will create a dataset with a query that is specific to the current report.

Report Data

                                                   (Related Page: How To Create a Report Dataset Reporting Services - SSRS)

Try it

1. In the Solution Explorer, right-click on Reports and choose Add > New Item, (Avoid using Add New Report for now, as this will launch the wizard instead of letting you specify details yourself).

2. In the Add New Item dialog, choose Report (not Report Wizard) and call it Summary Sales.rdl, then click Add.

3. SSDT will now display an empty report, and the Report Data panel should have appeared on the left side of the screen. If this panel is not visible, use CTRL-ALT-D to display it.

4. In the Report Data panel, right-click on Data Sources and choose Add Data Source…

5. Name the data source AdventureWorks, and change the selection from Embedded connection to Use shared data source reference.

6. Select AdventureWorks from the drop-down list. This is the project data source you configured previously.

7. Click OK and note that the new AdventureWorks data source has appeared in the Report Data panel. Note also that it has an icon containing an arrow. This shows that it is a reference to the project data source.

MindMajix YouTube Channel

Frequently Asked SSRS Interview Questions & Answers

List of Related Microsoft Certification Courses:

 SSIS Power BI
 SSAS SQL Server
 SCCM SQL Server DBA
 SharePoint BizTalk Server
 Team Foundation Server BizTalk Server Administrator

 

 

Join our newsletter
inbox

Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!

Course Schedule
NameDates
SSRS TrainingMar 23 to Apr 07View Details
SSRS TrainingMar 26 to Apr 10View Details
SSRS TrainingMar 30 to Apr 14View Details
SSRS TrainingApr 02 to Apr 17View Details
Last updated: 03 Apr 2023
About Author

Ravindra Savaram is a Technical Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.

read more
Recommended Courses

1 / 15