Viewers: in countries Watching now:
Discover how to create, manage, and deliver interactive reports—not just to print, but to dynamically explore enterprise-level data—with Reporting Services in SQL Server. In this course, author Simon Allardice concentrates on using Report Builder to build and format reports from a variety of data sources, but also shows how to perform basic administration tasks such as granting user access and organizing reports in the Report Manager. Plus, learn how to add interactive sorting and filtering functionality to your reports, and create column and pie charts to better express your data.
Note: These tutorials are applicable to both the 2008 and 2012 versions of SQL Server.
So that we can focus on using Reporting Services, there are awesome things I'm expecting you to know coming into this course. Now if you are already comfortable with SQL Server 2008 or SQL Server 2012, that's great. You are ready to go. But it isn't essential and you be an expert on SQL Server. What is essential is you understand at least the basics of relational databases. If I talk about tables and rows and columns, keys and relationships, you know what I mean. Now this database knowledge doesn't have to be from SQL Server, although that is most convenient. It could be from Access or Oracle, DB2 or My SQL, as relational databases are all very similar in concept.
But if you're completely new to databases, first take a look at our Foundations of Programming: Databases course that covers all the basic concepts. It is also helpful to know some SQL. You don't have to be an expert; just knowing how to write select statements is good. And as you'll see, you won't have to write much SQL if you don't want to, but SQL Server Reporting Services is a product built on top of a classic relational database. So the more of that classic relational database knowledge you already have, the more you will be able to get out of this product. So if you can write basic SQL queries, great; and if you are a complete expert, even better.
Now what if you have got some of this knowledge but just need a refresher on this. Well, we have a SQL Essential Training course and one of the quickest ways you could go through this is to take a look at the SQL Server 2008 Essential Training Course, particularly the Creating Databases and Retrieving Data with SQL chapters. And with this in mind, next I am going to quickly cover some setup questions you might have, some basic terminology, and what we actually need to get started.
There are currently no FAQs about SQL Server Reporting Services in Depth.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.