Create and Use Shared Data Sources in a SQL Server


show more An embedded data source is one that is defined only in relation to the report that it is being used in. In your SQL Server, you can pull out required data and use it across multiple reports. Learn how creating and using shared data sources lets you view information in multiple settings in this video. show less
please wait ...

Creating and using shared data sources

In all the reports I've created so far I've been creating and embedding a separate data source inside each report describing individually how each report will find and connect to its source of data. But as it's common to create a lot of reports that will connect to the same source--say the same database--we also have the idea of creating a shared data source, defining it once, and saving it and reusing it across multiple reports. You might wonder why I don't talk about these earlier. Well, it's because while shared data sources are great, they do add a little complexity that we just don't need right up front.

And the more familiar you are with creating a few of these embedded data sources, the easier it is to make shared ones. So I'm looking at a typical embedded data source here, like I've been doing all along. We're connecting to SQL Server, and I used the helper window in the Build button to create the connection string here. And here's the thing...

Creating and using shared data sources
Video duration: 8m 11s 3h 44m Advanced

Viewers:

An embedded data source is one that is defined only in relation to the report that it is being used in. In your SQL Server, you can pull out required data and use it across multiple reports. Learn how creating and using shared data sources lets you view information in multiple settings in this video.

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