Who it's for: This course introduces SQL Server users with Administrator access to SQL Server Reporting Services (SSRS).

What it is: SQL Server Reporting Services (SSRS) is a comprehensive SQL Server-based tool used to create, test, and deploy a variety of reports.

What you'll learn: The ability to sort, group, and summarize data is key as the amount of data we need to deal with increases. First, we focus on providing users with the ability to see the level of detail or summary they need in the order they need to see it. This is accomplished, not only by sorting and grouping, but by creating sub-reports, enabling the drilldown action on reports, and creating drill through reports. Exporting reports to other formats (Word, Excel, PowerPoint) is also addressed. When you have published an SSRS report, users can view the report interactively. In some situations, it can be advantageous to run reports automatically, either to improve performance through caching and snapshots, or to deliver reports to users – by using email or Windows file share. We cover these topics, along with scheduling, comments, subscriptions, and delivery. Finally, we take a look at tasks related to administering SSRS. This includes branding the web portal, setting up security users/groups and assigning SSRS security roles and tasks to the groups. The focus switches to reporting services performance and monitoring it via Task Manager, Event Viewer, and Performance Manager.

  Exercise Files - Download Before Starting the Course
Available in days
days after you enroll
  Course
Available in days
days after you enroll