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 ...
Get SQL Server 2016 Reporting Services Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
