From the course: SQL Server: Reporting Services

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Joining data tables

Joining data tables - SQL Server Tutorial

From the course: SQL Server: Reporting Services

Start my 1-month free trial Buy for my team

Joining data tables

“

- [Adam] Most SQL Server databases break data up across multiple related data tables. It's the configuration that makes relational databases relational. Adding data to a report that spans across tables is simplified using the dataset graphical interface. I'm going to create a new paginated report from the options here inside of the portal. Then, I'll choose the option to create a new blank report in Report Builder. Now, just like before, we need to create another data source. So I'll right click on the Data Sources folder and add a new one. I'll name this WideWorldImporters. Then, I'll embed the connection into the report, we'll connect to a SQL Server, and I'll press the Build button over here on the right. The server name will be my PC, and I'll use Windows Authentication. Then, using the dropdown menu, I'll select the WideWorldImporters database. I'll test the connection. That looks like it works, so I'll say OK, OK, and OK again to create the data source. Then, we'll add in our…

Contents