Dive into advanced data analysis techniques using SQL Server Reporting Services (SSRS) in this comprehensive tutorial. Learn to create, test, and deploy various reports while keeping up with changing business requirements. Master the use of data filters and report parameters to present tailored information to users. Explore data visualization tools including images, charts, data bars, sparklines, indicators, and gauges to enhance report presentation. Discover how to create map reports using spatial data and leverage report parts for efficient report creation. Gain hands-on experience with both Visual Studio and Report Builder environments, and learn to apply these skills to real-world reporting scenarios.
SQL Server Reporting Services - Data Analysis Advanced Tutorial
Overview
Syllabus
Start
Introduction
Working with Reporting Services Data
Data Filters and Data Regions
Applying Report Filters in VS
Applying and Removing Report Filters in RB
Introduction to Report Parameters
Creating Parameters in RB
Adjusting and Testing Parameter Properties
Creating Parameters in VS
Working with Reporting Services Data Recap
Introduction to Visualizing Data with Report Services
Uploading Images to SSRS
Creating New Reports with Pie Charts in VS
Selecting Fields and Formatting Labels in Charts
Creating, Formatting, and Testing Two Parameters
Adding Page Headers to Display Parameter Values
Adjusting Parameter Placeholder Properties
Creating Website Hyperlinks in a Report
Adding Images to Reports
Reorganizing the Parameters Pane
Adding Two More Parameters to an Existing Report
Concatenating Wildcards into Parameter Definition
Displaying No Rows Message for No Results
Databars, Sparklines, Indicators, Gauges, and Maps
Inserting Data Bars into Table Reports
Inserting Sparklines into Table Reports
Inserting Indicators into Table Reports
Inserting Gauges into Table Reports
Creating Maps with Map Wizard
Adding Parameters to a Map Report
Introduction to Report Parts
Publishing Report Parts to the ReportServer
Viewing Report Parts Folder in SSRS
Adding Logos to Table Reports in RB
Visualizing Data with Report Services Recap
Conclusion
Taught by
Learnit Training
