SQL Server: Reporting Services

Discover how to build, edit, and publish interactive reports using Reporting Services in SQL Server.

Introduction

• Present SQL data with Reporting Services
• What you should know
• Set up the example database

1. Get Started with SSRS

• What is SQL Server Reporting Services (SSRS)?
• Install SSRS
• Configure the report server
• Access the web portal
• Install Report Builder

2. Build a First Report

• Components of a report
• Create a report data source
• Create a dataset
• Add a data table with the wizard
• Joining data tables
• Format a report
• Reviewing report properties
• View, print, and export a report

3. Work with Data

• Create a shared data source
• Create a shared dataset
• Filtering data
• Grouping data in a report
• Understand matrixes
• Use aggregate functions

4. Build Interactive Reports

• Convert filters into parameters
• Report parameter properties
• Make a dynamic report title
• Add a parameter manually
• Report actions
• Sort records in a table

5. Create Charts

• Introduction to charts
• Create a chart
• Add additional data series
• Format charts

6. Additional Data Visualizations

• Gauges
• Indicators
• Data bars
• Create a sparkline dataset
• Display a sparkline
• Maps

7. Improve the Presentation

• Include header and footer details
• Add graphics and logos
• Align page elements
• Insert page breaks

8. Build a Web Portal Dashboard

• Add a key performance indicator (KPI)
• Create a dynamic KPI
• Organize the web portal with folders
• Customize the web portal branding

9. Mobile Report Publisher

• What is Mobile Report Publisher?
• Tour Mobile Report Publisher
• Exploring visuals and themes
• Connect visuals to data
• Add a time chart
• Create device-specific layouts
• View reports in the Power BI mobile app

10. SSRS Tips and Tricks

• Reuse report parts
• Subscribe to a report

Conclusion

• Next steps