MS SQL Server Reporting Services (“SSRS”) Course
This 4 day course is intended for students who need to learn and understand the full reporting lifecycle of designing, managing, and accessing reports in a Microsoft SQL Server 2014 environment.
Days 1 and 2 will familiarise attendees with the SQL Server Reporting Services (“SSRS”) development tools used to create and author reports, and will enable students to design initially basic, then more complex, reports. All of the data regions utilised in report design are covered here including tables, matrices, lists, and charts. Interactive features such as drilldown and drill-through reports are also covered in this section, as are the implementation and use of report parameters.
Day 3 builds upon the knowledge gained over the previous two days by covering advanced report design concepts such as using Analysis Services as a data source, making your reports more dynamic (such as allowing users to interactively select groups for a matrix through parameters), alternating background colours for table rows, and other handy tips to enable developers to design truly professional reports. Day 4 of the course deals more specifically with the role of the Report Server itself. Here, students will learn how to deploy reports to a Report Server, manage Report Server content, handle subscriptions, and control access to reports.
Concise coverage of the subject matter is augmented with plenty of hands-on exercises to facilitate the learning process and to enable students to quickly gain confidence in using SSRS.
Additionally, with the course structure being fully modularised, customised versions of this course can also be devised and delivered. For example, clients interested only in report development could attend just the first 3 days of the course omitting Report Server management ordinarily covered on day 4.
This course can be run at our London, Manchester and Guildford training centre. We also frequently provide SQL Server training at our customer’s offices.
Upon successful completion of this course, delegates will be able to:
- Understand the Reporting Services Architecture and Report Lifecycle
- Create and Edit Reports using Tables, Matrices, and Lists
- Use Expressions to Enhance Report Capabilities
- Enhance Reports by Implementing Interactive Features
- Incorporate Charts, Indicators, and other Graphical Features into Reports
- Work with Data Sources and Datasets
- Understand Advanced Report Design Concepts
- Set up Report Publishing and Execution Settings
- Manage Report Server Content with Report Manager
- Distribute Reports with Subscriptions
- Secure Report Server Resources
No prior knowledge of the subject matter is assumed. However, students should ideally be familiar with basic programming concepts, and understand the fundamental design of relational databases and data normalization.
Some prior working knowledge of SQL Server 2014 (or previous version), and the use of SQL Server Management Studio, is assumed. Attendees should additionally be familiar with the SQL query language, in particular the SELECT statement used for retrieving data.
Our courses run from 9.30 am to approximately 4.30 pm. While you are with us we are focused on offering you a relaxed and productive learning environment. When you book a course with use you get the following:
- A full colour SSRS course manual.
- The exercises that you have worked on during your course to allow you to practice afterwards.
- USB stick to take the exercises away (where relevant).
- Freshly prepared lunch in our onsite cafeteria.
- Refreshments though out the day.
- Training in fully air conditioned facilities from an experienced SQL instructor.
- Overview of Reporting Services
- The Reporting Life Cycle
- Reporting Services Architecture
- Reporting Services Tools
- Controlling Layout with Rectangles
- Interactive Sorting
- Drill-Down Reports
- Document Maps
- Using Parameters to Restrict Query Results
- Using Parameters to Filter Report Data
- Creating Dynamic Parameter Lists
- Cascading Parameters
- Displaying User Selected Parameters in a Report
- Drill-Through Reports
- Working with Charts
- Indicators and KPIs
- Data Bars
- Spark Lines
- Overview of Report Builder
- Designing a Report in Report Builder
- Implementing Report Parts
- Using an Analysis Services Data Source
- Implementing Maps with Spatial Data
- Embedding Code in Reports
- Implementing Custom Assemblies
- Creating Templates
- Using Parameters with a Stored Procedure
- Dynamic Data Sources and Datasets
- Dynamic Grouping
- Hiding/Showing Columns
- Adjacent Groups
- Recursive Hierarchy Grouping
- Alternating Background Colours
- Compact Grouping Layout
- Handling the Absence of Data in a Report
- Other Report Design Tips and Tricks
- Configuring Reporting Services
- Deploying Reports
- Introduction to the Report Manager
- Executing Reports on Demand
- Managing Report Server Content
- Linked Reports
- Managing Data Source Properties
- Caching Reports
- Report Snapshots
- Report History
- The My Reports Folder
- Rendering Reports to Different Formats
- Introduction to Report Subscriptions
- Creating a Standard Subscription
- Creating a Data-Driven Subscription
- Managing Report Subscriptions
- Securing Report Server Content
- Implementing Data Security
- Using URL Access to Display a Report