Discover how to build, edit, and publish interactive reports using Reporting Services in SQL Server.
Overview
Syllabus
Introduction
- Present SQL data with Reporting Services
- What you should know
- Set up the example database
- What is SQL Server Reporting Services (SSRS)?
- Install SSRS
- Configure the report server
- Access the web portal
- Install Report Builder
- 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
- Create a shared data source
- Create a shared dataset
- Filtering data
- Grouping data in a report
- Understand matrixes
- Use aggregate functions
- Convert filters into parameters
- Report parameter properties
- Make a dynamic report title
- Add a parameter manually
- Report actions
- Sort records in a table
- Introduction to charts
- Create a chart
- Add additional data series
- Format charts
- Gauges
- Indicators
- Data bars
- Create a sparkline dataset
- Display a sparkline
- Maps
- Include header and footer details
- Add graphics and logos
- Align page elements
- Insert page breaks
- Add a key performance indicator (KPI)
- Create a dynamic KPI
- Organize the web portal with folders
- Customize the web portal branding
- 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
- Reuse report parts
- Subscribe to a report
- Next steps
Taught by
Adam Wilbert