SQL Server Reporting Services: Data Analysis Master Tutorial

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join

Exercise Files: https://learnitanytime.com/p/exercise-files-sql-server-reporting-services-data-analysis-master

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: First, we address how to extend report services by using expressions, embedded code, and custom assemblies. You will learn how to create a Class Library project to store Visual Basic code and also how to save a Report Template containing embedded code that can be used for new reports. Next, we introduce the design and publication of reports that are intended for consumption on mobile devices, such as smartphones and tablets. SSRS includes support for mobile reports, although the tools that are used to design and publish mobile reports are different from the tools used for the paginated reports discussed in earlier modules. Finally, you will learn about the element types that you can add to your SSRS mobile reports. And you will design, create, test, and publish mobile reports. You will learn how to access these reports in the web portal as well as via the Power BI app on your smartphone or tablet.

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com

For Private Group Trainings please visit:
https://www.learnit.com/private-group-classes-workshops

Manuals: https://bit.ly/30xZb59
Username: manuals
Password: password

Start 0:00
Introduction 0:03
Introduction to Extending Reporting Services 1:45
Expressions and Embedded Code Overview 2:34
Creating Expressions to Determine Colors 3:59
Creating Expressions Using Global Fields 7:01
Embedding Code in a Report 10:17
Creating a Class Library Project 15:08
Creating Function Procedures in VB Using Code Editor Help 17:06
Reviewing the Function Procedure 24:46
Copying Code from Class Library to Report Properties 28:59
Saving Blank Reports with Embedded Code as a Template 32:41
Using Templates with Embedded Code to Create New Reports 35:00
Custom Assemblies Overview 43:02
Modifying Functions to Public and Shared 44:28
Adding CS Projects to the Solution 45:42
Pasting DLL Files Into Directories 53:53
Testing a Custom Assembly 54:52
Extending Reporting Services Recap 1:00:01
Organizing in SSRS 1:02:18
Software Requirements for Mobile Reports 1:04:16
Introduction to Mobile Reports 1:04:48
Creating a Dataset for Mobile Reports 1:07:03
Creating Datasets for Mobile with Data by Year 1:09:13
Touring the Mobile Report Publisher Interface 1:11:23
Launching and Verifying Mobile Report Publisher from SSRS 1:15:28
Adding Time Charts to the Design Grid 1:16:34
Connecting to Mobile Datasets and Viewing Data 1:18:20
Changing Time Chart Visualization and Data Properties 1:20:29
Adding and Adjusting Number Gauges 1:20:57
Adding and Adjusting Time Navigators 1:21:37
Adding and Adjusting Chart Data Grids 1:22:00
Setting Chart Data Grids to Respond to the Time Navigator 1:25:40
Applying and Designing Palletes in the Mobile Report 1:26:20
Saving the Report to the Report Server 1:27:15
Viewing a Mobile Report in the SSRS Web Portal 1:28:16
Writing Queries to See All Table Fields in SSMS 1:29:12
Investigating Query Results for Pertinent Fields 1:31:05
Writing the KPI Query 1:32:32
Creating a KPI in SSRS 1:41:42
Viewing KPI Related Content in the Web Portal 1:47:57
Accessing KPIs and Mobile Reports from Power BI Mobile App 1:48:31
Mobile Reports Recap 1:50:38
Conclusion 1:51:49

#sqlserver #ssrs #sqlservertutorial

(C) 2023 Learnit, Inc.

Any illegal reproduction of this content will result in immediate legal action.