Play all

Start

Introduction

Introduction to Summarizing Report Data

Sorting Table Reports

Setting Up Interactive Sorting on Report Fields

Summarizing Data Definitions and Comparisons

Adding an Order by Clause to a Query in SSMS

Creating the Main Report

Formatting Changes and Saving the Main Report

Creating the SubReport

Embedding the SubReport in the Main Report

Creating a Drilldown Report

Creating a Drill Through Target Report

Setting Parameters to Allow and Default to Null Values

Creating a Drill Through Summary Report

Making Chart Modifications

Adding Concatenated Tooltips to a Column

Drill Through Summary and Target Report Exercise

Summarizing Report Data Recap

Introduction to Sharing Reports

Schedule Uses and Types

Redeploying Projects Properly

Setting Up a Schedule in SSRS

Introduction to Caching Snapshots and Comments

Creating a Cache that Expires on a Schedule for a Dataset

Creating History Snapshots for a Report

Reviewing Manage Options and Adding Comments in Reports

Setting Up Users and Groups

Account Settings in RSCM

Setting Up File Share Folders

Setting Up Subscriptions

Reviewing Subscription Options in SSRS

Sharing Reports Recap

Introduction to Administering Reporting Services

Reviewing, Configuring, and Branding the Web Portal

Security Assignments

Editing Security Role Assignments at the Report Level

Introduction to Reporting Services Performance

Checking Key Processes in Task Manager

Monitoring and Fixing Errors

Accessing Performance and Resource Monitors

Accessing Process Monitors

Administering Reporting Services Recap

Conclusion

Description:

Master SQL Server Reporting Services (SSRS) in this comprehensive tutorial designed for SQL Server users with Administrator access. Learn to create, test, and deploy various reports while exploring advanced data analysis techniques. Dive into sorting, grouping, and summarizing data, creating sub-reports, enabling drilldown actions, and developing drill-through reports. Discover how to export reports to different formats and set up automatic report generation for improved performance. Explore caching, snapshots, and report delivery methods, including email and Windows file share. Gain insights into SSRS administration, including web portal branding, security setup, and performance monitoring using Task Manager, Event Viewer, and Performance Manager. Enhance your data analysis skills and become proficient in managing and optimizing SSRS for your organization's reporting needs.

SQL Server Reporting Services - Data Analysis Expert Tutorial

Learnit Training

Add to list

#Computer Science #Information Technology #Windows Systems Administration #Windows Server #Microsoft SQL Server #Data Science #Data Analysis #Data Summarization