Play all

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

Description:

Master SQL Server Reporting Services (SSRS) for advanced data analysis in this comprehensive tutorial. Learn to extend report services using expressions, embedded code, and custom assemblies. Create a Class Library project for Visual Basic code and save Report Templates with embedded code. Explore mobile report design and publication for smartphones and tablets. Discover various element types for SSRS mobile reports, and learn to design, create, test, and publish them. Access reports through the web portal and Power BI app. Gain hands-on experience with time charts, number gauges, time navigators, and chart data grids. Write queries, create KPIs, and investigate query results for pertinent fields. Perfect for SQL Server users with Administrator access looking to enhance their SSRS skills.

SQL Server Reporting Services - Data Analysis Master Tutorial

Learnit Training

Add to list

#Computer Science #Information Technology #Windows Systems Administration #Windows Server #Microsoft SQL Server #Data Science #Data Analysis #Programming #Programming Languages #C# #Visual Basic