Create and Use shared data sets SQL Server


show more Shared data sets let you create multiple versions of reports from your SQL Server database. Additionally, you can use the function to create a single query that can accommodate multiple requests. Follow along as this online video tutorial guides you through the steps of creating and using shared data sets. show less
please wait ...

Creating and using shared data sets

And with the same idea as creating shared data sources, we can also create shared datasets. Now, this is not quite as common across the board, as you are more likely to need different datasets across different reports, but they can be useful. Now as with creating other modular components like shared data sources or report parts, I like having a folder to put my shared data sets in to make them easy to find. So just create a new folder here, share Data Sets, and while we created a new data source from this window, we actually go back into Report Builder to create a shared dataset.

So I'll open up Report Builder, but I'm not going to create a report because on the Getting Started page is another option we haven't seen yet. None of the wizards, it's the second one on the left here, the New Dataset. Now the first think it's going to ask for is to choose a shared data source connection. Shared datasets must use a shared data source so creating the shared data source come...

Creating and using shared data sets
Video duration: 3m 51s 3h 44m Advanced

Viewers:

Shared data sets let you create multiple versions of reports from your SQL Server database. Additionally, you can use the function to create a single query that can accommodate multiple requests. Follow along as this online video tutorial guides you through the steps of creating and using shared data sets.

Subjects:
Developer IT
Software:
SQL Server
Author:
please wait ...