This course aims to teach SQL Server users with Administrator access how to utilize SQL Server Reporting Services (SSRS) for creating, testing, and deploying various reports. By the end of the course, learners will be able to extend report services using expressions, embedded code, and custom assemblies. They will also learn to design and publish reports for mobile devices, create mobile reports, and access them through the web portal and Power BI app. The course employs a tutorial-based teaching method with hands-on exercises and practical examples. The intended audience for this course includes SQL Server users with Administrator access looking to enhance their reporting skills using SSRS.
SQL Server Reporting Services - Data Analysis Master Tutorial
Overview
Syllabus
Start
Introduction
Introduction to Extending Reporting Services
Expressions and Embedded Code Overview
Creating Expressions to Determine Colors
Creating Expressions Using Global Fields
Embedding Code in a Report
Creating a Class Library Project
Creating Function Procedures in VB Using Code Editor Help
Reviewing the Function Procedure
Copying Code from Class Library to Report Properties
Saving Blank Reports with Embedded Code as a Template
Using Templates with Embedded Code to Create New Reports
Custom Assemblies Overview
Modifying Functions to Public and Shared
Adding CS Projects to the Solution
Pasting DLL Files Into Directories
Testing a Custom Assembly
Extending Reporting Services Recap
Organizing in SSRS
Software Requirements for Mobile Reports
Introduction to Mobile Reports
Creating a Dataset for Mobile Reports
Creating Datasets for Mobile with Data by Year
Touring the Mobile Report Publisher Interface
Launching and Verifying Mobile Report Publisher from SSRS
Adding Time Charts to the Design Grid
Connecting to Mobile Datasets and Viewing Data
Changing Time Chart Visualization and Data Properties
Adding and Adjusting Number Gauges
Adding and Adjusting Time Navigators
Adding and Adjusting Chart Data Grids
Setting Chart Data Grids to Respond to the Time Navigator
Applying and Designing Palletes in the Mobile Report
Saving the Report to the Report Server
Viewing a Mobile Report in the SSRS Web Portal
Writing Queries to See All Table Fields in SSMS
Investigating Query Results for Pertinent Fields
Writing the KPI Query
Creating a KPI in SSRS
Viewing KPI Related Content in the Web Portal
Accessing KPIs and Mobile Reports from Power BI Mobile App
Mobile Reports Recap
Conclusion
Taught by
Learnit Training
