From the course: SQL Server: Reporting Services

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Create a shared dataset

Create a shared dataset - SQL Server Tutorial

From the course: SQL Server: Reporting Services

Start my 1-month free trial

Create a shared dataset

“

- Just like a shared data source can be referenced by a number of different reports to connect them all to the same database. A shared dataset can be used to query the same data from a database. Shared datasets make management of the underlining queries easier since again, they create a single reference that needs to be updated if the structures of the database changes. Rather than updating the dataset in each and every individual report. The process of creating a shared dataset starts in the same way in any web portal. You come up here to the New button, and then come down and choose Dataset. However, you'll immediately notice a difference from the data source workflow. We're passed into Report Builder, and a new dataset wizard starts up. Shared datasets must be created off of a shared data source, so I'm going to use the one that connects to the Wide World Importer's database that we saved into the report server, and then press the Create button. That brings us back into a query…

Contents