Zenler Player
Your course is loading. Hang tight.
SQL Server Reporting Services for Developers and DBAs
Back to curriculum
0% Complete
0% Complete
Who is this course for?
Who is Greg?
What will I learn in this course?
Configuring your lab environment
The reporting challenge
Why SQL Server Reporting Services
Reporting Services components
Report Server
Report Manager
Report Manager Branding
Report Designer
RS Command Line Utitlity
Report Builder
Lab 1a: Core concepts - Installing Reporting Services or Power BI Report Server
Lab 1b: Core concepts - Installing SQL Server Data Tools
Lab 1c: Core concepts - Installing Report Builder
Report Wizard
Report Definition Language (RDL)
Data Sources
Datasets
Reporting Services Toolbox
Tables
Text Boxes
Lines and Rectangles
Images
Deploying reports
Previewing and exporting reports
Creating report templates
Lab 2: Designing reports
Lab 2 Walkthrough
Quiz 2: Designing reports
Tablix
Charts
Gauges
Other visualizations
Expressions
Collections
Lab 3: Common report elements
Lab 3 Walkthrough
Quiz 3: Common report elements
Report parameters
Query parameters
Available values
Default values
Dynamic parameter values
Multi-valued parameters
Parameter-related expressions
Subreports
Drill-down reports
Report linking
Document maps
Interactive sorting
Lab 4: Creating dynamic reports
Lab 4 Walkthrough
Quiz 4: Creating dynamic reports
Role based security model
Report Manager and UAC
Linked reports
Unattended execution account
Backup encryption key
Lab 5: Report security
Lab 5 Walkthrough
Quiz 5: Report security
Intermediate report format
Cached reports
Report snapshots
Report subscriptions
Standard subscriptions
Data-driven subscriptions
Data-driven subscriptions in Standard Edition
Lab 6: Report execution and subscriptions
Lab 6 Walkthrough
Quiz 6: Report execution and subscriptions
Why Report Builder?
Launching Report Builder
SQL Server spatial data concepts
Creating a map-based report
Lab 7: End-user reporting with Report Builder
Lab 7 Walkthrough
Quiz 7: End-user reporting with Report Builder
Embedding code
Referencing .NET assemblies
Reporting from Analysis Services
Sharing datasets
Sharing report parts
ATOM data feed concepts
Using a data feed as a data source
Quiz 8: Advanced reporting options
Summary and further steps
Module 0: Getting started
Who is this course for?
Preview
Who is Greg?
Preview
What will I learn in this course?
Preview
Configuring your lab environment
Module 1: Core concepts
The reporting challenge
Why SQL Server Reporting Services
Reporting Services components
Report Server
Report Manager
Report Manager Branding
Report Designer
RS Command Line Utitlity
Report Builder
Lab 1a: Core concepts - Installing Reporting Services or Power BI Report Server
Lab 1b: Core concepts - Installing SQL Server Data Tools
Lab 1c: Core concepts - Installing Report Builder
Module 2: Designing reports
Report Wizard
Report Definition Language (RDL)
Data Sources
Datasets
Reporting Services Toolbox
Tables
Text Boxes
Lines and Rectangles
Images
Deploying reports
Previewing and exporting reports
Creating report templates
Lab 2: Designing reports
Lab 2 Walkthrough
Quiz 2: Designing reports
Module 3: Common report elements
Tablix
Charts
Gauges
Other visualizations
Expressions
Collections
Lab 3: Common report elements
Lab 3 Walkthrough
Quiz 3: Common report elements
Module 4: Creating dynamic reports
Report parameters
Query parameters
Available values
Default values
Dynamic parameter values
Multi-valued parameters
Parameter-related expressions
Subreports
Drill-down reports
Report linking
Document maps
Interactive sorting
Lab 4: Creating dynamic reports
Lab 4 Walkthrough
Quiz 4: Creating dynamic reports
Module 5: Report security
Role based security model
Report Manager and UAC
Linked reports
Unattended execution account
Backup encryption key
Lab 5: Report security
Lab 5 Walkthrough
Quiz 5: Report security
Module 6: Report execution and subscriptions
Intermediate report format
Cached reports
Report snapshots
Report subscriptions
Standard subscriptions
Data-driven subscriptions
Data-driven subscriptions in Standard Edition
Lab 6: Report execution and subscriptions
Lab 6 Walkthrough
Quiz 6: Report execution and subscriptions
Module 7: End-user reporting with Report Builder
Why Report Builder?
Launching Report Builder
SQL Server spatial data concepts
Creating a map-based report
Lab 7: End-user reporting with Report Builder
Lab 7 Walkthrough
Quiz 7: End-user reporting with Report Builder
Module 8: Advanced reporting options
Embedding code
Referencing .NET assemblies
Reporting from Analysis Services
Sharing datasets
Sharing report parts
ATOM data feed concepts
Using a data feed as a data source
Quiz 8: Advanced reporting options
Module 9: Next steps
Summary and further steps
×
This is an unpublished lesson. This lesson will not be shown for students unless you set it as Public.
Back to Dashboard
No contents are available in this lesson!
No lessons available !
Back to Dashboard
Lesson contents locked
Enroll to unlock this lesson.
Enroll to unlock
Next Lesson