Skip to main content
SQL Server Reporting Services
The ability to report, analyse and visualise data in a variety of interactive, mobile and printed reports is essential to control and manage your organisation. such reports and dashboards are increasingly designed and deployed using Microsoft SQL Server Reporting Services (SSRS). This course uses SQL Server 2017 but is equally suitable for SQL 2016 and other previous versions.
Book your team training at your premises
- Date
- Venue
- Cost
- More info
- Date and time to suit you
- VenueWe will train your team
at your offices - CostContact us for price
- Fill in the form and we'll be in touch
within 15 minutes (Mon-Fri 9-5)
Book your place
- Date
- Venue
- Cost
- Availability
- Date22 Jul 2019
- VenueWorcester
- Cost£1,197
- AvailabilityAvailable
- Book Now
- Date11 Nov 2019
- VenueWorcester
- Cost£1,197
- AvailabilityAvailable
- Book Now
Guaranteed to run
This course covers the design of reports in Report Builder. It also includes mobile reports and key performance indicators. Reports will include tablix, charts and gauges. Different types of interactive content will be used. Other topics covered include managing security, exporting reports and delivering reports to folders and by email. Exercises are included to consolidate the skills taught.
IT professionals who need to design, deploy and manage reports for SQL Server Reporting Services.
- Develop reports, mobile reports and key performance indicators
- Include graphical content in reports
- Use expressions for conditional formatting in reports
- Add parameters to reports
- Link reports to provide drill down functionality
- Deploy reports to a Reporting Services server
- Manage Reporting Services content
- Brand the Web Portal
- Use push subscriptions to email reports
This course will give your organisation the ability to develop, deploy and manage Reporting Services reports across the organisation. These reports will often present information in an impressive graphical format and incorporate interactive features.
This course will equip you with the skills to understand and use SQL Server Reporting Services. You will have the confidence to develop complex reports and manage Reporting Services. You will be able to use both Report Builder and the Reporting Services Web Portal.
- Overview of SQL Server Reporting Services
- Features in Different SQL Server Editions
- Reporting Services Architecture
- Installing Reporting Services
- Configuring Reporting Services
- Paginated Reports
- Mobile Reports and Key Performance Indicators
- Report Builder
- Launching Report Builder
- Using Wizards to Create a Report
- Using Report Builder
- Report Properties
- SQL Server Data Tools
- Overview of Tables
- Creating a Report
- Adding a Table to a Report
- Grouping Rows
- Properties Window
- Other Content
- Saving a Report
- Drill Down Reports
- Shared Data Sources
- Shared Datasets
- Overview of Charts and Gauges
- Charts
- Gauges
- Other Types of Chart and Gauge
- Maps
- Overview of Expressions
- Entering Expressions
- Example of Expressions
- Aggregate Functions
- Decision Making Function
- Reporting Services Variables
- Embedded Code in Reports
- Action
- Embedded HTML in Text Boxes
- Overview of Advanced Report Features
- Lists
- Report Parameters
- Linked Reports
- Subreports
- Matices
- Images
- Report Parts
- Overview of Reporting Services Security
- System Tasks and Roles
- Item Tasks and Roles
- Creating System and Item Roles
- Data Source Security
- Using the Web Portal
- Favourites
- Report Properties
- Processing Options
- Report History
- Schedules
- Subscriptions
- Using Reports From Applications
- Reporting Services Settings
- Monitoring Reporting Services
No previous knowledge of Microsoft SQL Server Reporting Services is required. A basic knowledge of Microsoft SQL Server is required. This could be gained from our SQL Server Essentials course or through work experience.
About the Lead Trainer
Stephen has 20 years’ experience in the IT industry. A member of the Institute of IT Training and British Computer Society with a degree in business computing systems, Stephen has a solid foundation upon which his ITIL® Expert qualification sits.
