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 report data source - SQL Server Tutorial
From the course: SQL Server: Reporting Services
Create a report data source
- [Instructor] The easiest and most common way to start building your report is to begin at the report server web portal. From there, you'll press the New button to start a new Paginated Report. Depending on the width of your browser window, you might just see the plus icon without the text New next to it. The portal also scales with your browser's zoom level, so you might want to zoom out if you're not seeing all of the text. For instance, in the Chrome browser, if I zoom up to 110%, you'll just see the plus icon there. Let's go back down to 100%. So by going to New, and choosing Paginated Report, that'll start up the Report Builder application. This'll present us with some options to choose a wizard to help us set up the report. To start out though, I'm going to choose the Blank Report option at the bottom. The options presented in the wizards will make more sense later on, once we have a good idea of what's going on behind the scenes. The Report Builder application is organized…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
Components of a report2m 1s
-
(Locked)
Create a report data source6m 27s
-
(Locked)
Create a dataset5m 16s
-
Add a data table with the wizard4m 44s
-
(Locked)
Joining data tables5m 38s
-
(Locked)
Format a report6m 35s
-
(Locked)
Reviewing report properties5m 1s
-
(Locked)
View, print, and export a report2m 3s
-
-
-
-
-
-
-
-
-
-