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.
- Introduction (1:42)
- Introduction to Extending Reporting Services (0:49)
- Expressions and Embedded Code Overview (1:25)
- Creating Expressions to Determine Colors (3:02)
- Creating Expressions Using Global Fields (3:15)
- Embedding Code in a Report (4:51)
- Creating a Class Library Project (1:58)
- Creating Function Procedures in VB Using Code Editor Help (7:39)
- Reviewing the Function Procedure (4:13)
- Copying Code from Class Library to Report Properties (3:41)
- Saving Blank Reports with Embedded Code as a Template (2:18)
- Using Templates with Embedded Code to Create New Reports (8:01)
- Custom Assemblies Overview (1:27)
- Modifying Functions to Public and Shared (1:13)
- Adding CS Projects to the Solution (8:11)
- Pasting DLL Files Into Directories (0:58)
- Testing a Custom Assembly (5:09)
- Extending Reporting Services Recap (2:16)
- Organizing in SSRS (1:58)
- Software Requirements for Mobile Reports (0:31)
- Introduction to Mobile Reports (2:14)
- Creating a Dataset for Mobile Reports (2:10)
- Creating Datasets for Mobile with Data by Year (2:09)
- Touring the Mobile Report Publisher Interface (4:04)
- Launching and Verifying Mobile Report Publisher from SSRS (1:06)
- Adding Time Charts to the Design Grid (1:45)
- Connecting to Mobile Datasets and Viewing Data (2:09)
- Changing Time Chart Visualization and Data Properties (0:28)
- Adding and Adjusting Number Gauges (0:40)
- Adding and Adjusting Time Navigators (0:23)
- Adding and Adjusting Chart Data Grids (3:40)
- Setting Chart Data Grids to Respond to the Time Navigator (0:39)
- Applying and Designing Palletes in the Mobile Report (0:55)
- Saving the Report to the Report Server (1:00)
- Viewing a Mobile Report in the SSRS Web Portal (0:56)
- Writing Queries to See All Table Fields in SSMS (1:52)
- Investigating Query Results for Pertinent Fields (1:27)
- Writing the KPI Query (9:10)
- Creating a KPI in SSRS (6:15)
- Viewing KPI Related Content in the Web Portal (0:34)
- Accessing KPIs and Mobile Reports from Power BI Mobile App (2:07)
- Mobile Reports Recap (1:11)
- Conclusion (1:21)