Delegates attending the SQL Server Reporting Services course will learn how to use (SSRS) to design, create, deploy, secure and manage reports. The course provides a fundamental understanding of the components of a Reporting Services deployment exploring its basic architecture and terminology. You will learn how to create tabular, matrix, chart and list reports that employ datasets based on ad-hoc queries and stored procedures. As you progress you'll learn to add custom expressions, custom functions and format your reports, implement shared data sources, interactive sorting, drill-down capabilities, and create parameter based reports using the Report Designer. Reports including gauges, indicators, spark lines and maps will also be introduced. The course will introduce both the Visual Studio (SQL Server 2008 Business Intelligence Development Studio (BIDS) for SSRS 2008R2 and SQL Server Data Tools (SSDT) for SSRS 2012 through to 2016) project environment and ReportBuilder 3.0 application for creating, saving and deploying reports. The latter part of the course covers the deployment, management and customisation of Reporting Services projects components and saving of reports, data sets and data sources to the SSRS repository. In this section you will learn how to manage security and access to reports through user roles and accounts. You will also learn how to schedule the execution and caching of reports, and automate the delivery of reports in selected render formats. An introduction to the concepts of accessing reports using URL access and the Reporting Services Web Service API, and the application integration options provided by SSRS will be provided to serve as a taster of how your reports might be integrated into your own applications. This course is suitable for delegates working with all versions of SQL Server from SQL Server 2008 through to SQL Server 2016.
This course assumes no prior knowledge of SQL Server Reporting Services. This course does assume prior knowledge of the SQL language to the level of the SQL Server Database Querying course.
A comprehensive set of reference notes covering course topics and follow-up telephone support.
|All our courses run in London and Bristol, or can be tailored to requirements at your own offices. For alternative dates, please email or call us on 0208 269 4260|
|All prices are per person and are subject to VAT|
15% discount for groups of four delegates.
10% discount for groups of three delegates.
(This offer applies for delegates on the same public scheduled course on the same date.)
"The whole experience was great. Trainer and staff were extremely helpful and approachable."
Faithful & Gould
"The trainer's knowledge was very strong and he was able to answer all my questions. Admin staff were very friendly and helpful."
"I am writing to say thank you for organising my FileMaker training day; I learned so much with my trainer, Nick, and have come away with such a great database. It delighted both the Director and my job share partner. I feel I have left with a great amount of knowledge that can help the business immensely. I learned more than I thought I would and would like to thank Transmedia for being so helpful!"