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

Working with published data sources

So far, you've already been working with data sources that were published back in Chapter 3, Advanced Report Authoring with SQL Server Data Tools. What if you want to create a new shared data source?

Unfortunately, there is no direct method to create a shared data source within Report Builder. However, we can create it within the Report Portal, and then use it in Report Builder.

Let's see how to do that with this recipe.

Getting ready

For this example, we're going to use the WideWorldImporters database, not the Data Warehouse (DW) version.

We'll use report builder later in this recipe, so go ahead and open report builder if it is not open to bring up the Getting Started window, or go to File | New in order to bring ...

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