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.
- Introduction (1:48)
- Introduction to Summarizing Report Data (0:42)
- Sorting Table Reports (2:16)
- 03 Setting Up Interactive Sorting on Report Fields (2:27)
- Summarizing Data Definitions and Comparisons (2:12)
- Adding an Order by Clause to a Query in SSMS (2:29)
- Creating the Main Report (5:02)
- Formatting Changes and Saving the Main Report (0:42)
- Creating the SubReport (4:32)
- Embedding the SubReport in the Main Report (2:42)
- Creating a Drilldown Report (4:48)
- Creating a Drill Through Target Report (6:59)
- Setting Parameters to Allow and Default to Null Values (4:25)
- Creating a Drill Through Summary Report (4:24)
- Making Chart Modifications (2:10)
- Adding Concatenated Tooltips to a Column (4:52)
- Drill Through Summary and Target Report Exercise (1:44)
- Summarizing Report Data Recap (2:02)
- Introduction to Sharing Reports (0:59)
- Schedule Uses and Types (2:23)
- Redeploying Projects Properly (2:28)
- Setting Up a Schedule in SSRS (3:52)
- Introduction to Caching Snapshots and Comments (1:32)
- Creating a Cache that Expires on a Schedule for a Dataset (1:44)
- Creating History Snapshots for a Report (1:14)
- Reviewing Manage Options for a Report and Adding Report Comments (2:24)
- Setting Up Users and Groups (2:37)
- Account Settings in RSCM (2:07)
- Setting Up File Share Folders (0:44)
- Setting Up Subscriptions (2:13)
- Reviewing Subscription Options in SSRS (1:57)
- Sharing Reports Recap (1:04)
- Introduction to Administering Reporting Services (4:12)
- Reviewing, Configuring, and Branding the Web Portal (3:27)
- Security Assignments (2:45)
- Editing Security Role Assignments at the Report Level (4:20)
- Introduction to Reporting Services Performance (1:53)
- Checking Key Processes in Task Manager (1:12)
- Monitoring and Fixing Errors (7:47)
- Accessing Performance and Resource Monitors (3:00)
- Accessing Process Monitors (1:43)
- Administering Reporting Services Recap (2:18)
- Conclusion (1:21)