Microsoft SQL Server Reporting Services

  This course is intended for information technology (IT) professionals and developers who need to implement reporting solutions by using Microsoft SQL Server Reporting Services. 

• Overview of SQL Server Reporting Service
• Installing Reporting Services
• Reporting Services Tools  
• Creating a Basic Table Report
• Formatting Report Pages
• Calculating Values Lab: Authoring Basic Reports

• Interactive Navigation
• Displaying Data Lab: Enhancing Basic Reports  
• Using Dynamic Visibility
• Using Document Maps
• Initiating Actions
• Using a List Data Region  
• Publishing Reports
• Executing Reports
• Creating Cached Instances
• Creating Snapshots and Report History Lab: Publishing and Executing Reports

• Defining Report Data
• Using Parameters and Filters
• Using Parameter Lists Lab: Manipulating Data Sets
• Using Parameters to Restrict Query Results
• Using Parameters to Filter Report Data
• Creating Dynamic Parameter Lists
• Using Parameters with a Stored Procedure
• Displaying All Categories in a Parameter List
•   Creating Report Models
• Using Report Builder Lab: Using Report Models

• Publishing Reports
• Executing Reports
• Creating Cached Instances
• Creating Snapshots and Report History 
• Publishing and Executing Reports
• Creating a Standard Subscription
• Creating a Data-Driven Subscription

• Administer the reporting server
• Monitor performance and reliability
• Administer the Report Server databases
• Administer security
• Upgrade to Reporting Services 2019
• Query server information using a Web service
• Automate report management.
• Render reports
• Create custom code