O'Reilly logo

SQL Server 2016 Reporting Services Cookbook by Robert C. Cain, Dinesh Priyankara

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Managing data sources

Reports are published with connection details of shared data sources and they are stored in a common folder called data sources. However, during the publish, developer has a freedom to change the default folder for data sources for the solution, hence additional folders that hold data sources in the portal is not unusual.

Getting ready

There is no specific routine or pre-processes done for managing data sources. If all data sources are stored in the standard Data Sources folder, you will work with that folder, else you will be working with multiple folders. When you open the portal, you can see the folder as shown in the following screenshot:

Figure 10.01

If you open the folder, you can see data sources added from all solutions. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required