Students Will Learn

Working with tables and using the Tablix control to manage row-level and/or column-level groups

Displaying pivot-table style data using the Matrix control

Adding images, page headers, page footers and textboxes to reports

Adding charts and gauges to reports

Rendering reports as Excel, Word or PDF files

Defining input parameters to allow users to filter data at runtime

Using Report Builder 3.0 to create reports

Linking reports and using sub-reports

Using Expression Builder to define custom fields and conditional formatting

Defining which users and groups can view/manage reports and report models

Defining snapshot reports to automate report generation and delivery

Configuring report caching to improve performance

Course Description

This course introduces Microsoft's SQL Server Reporting Services 2014 (SSRS) utility. It begins with a discussion of the Reporting Services architecture and how to set up Reporting Services servers. Students will install and configure Reporting Services, and perform hands-on exercises where they create various types of reports, including basic table-based reports, parameterized reports, drilldown reports, linked reports, sub-reports, matrix reports (pivot tables), free-form reports and reports with charts and gauges. Students learn how to group data and add subtotals and totals to reports, as well as how to add custom calculations using the built-in functions or using custom functions written in .NET. Also demonstrated are all of the data sources for reports that Reporting Services supports including: SQL Server databases, Access databases, XML files, Oracle databases, data warehouses and Analysis Services data cubes.

Report Models, and how they can support end users creating ad-hoc reports, are covered and students practice with them in comprehensive hands on exercises. This includes a demonstration of Report Builder, which is a free report authoring tool from Microsoft. The course ends with a complete overview of Report Server administration, including how to deploy and secure reports, how to schedule automatic report generation and delivery, how to backup reports, how to store previous copies of reports in history folders, and how to maintain and troubleshoot Report Servers.

Students can retake any portion of a class that has been completed, within 12 months at no extra cost

There are no registration fees or cancellation fees

Testimonials

Our instructor was an excellent teacher and definitely a subject matter expert.
I attended multiple trainings and she is one of the best I have ever had: very articulate, clear explanation on most complex topics, very nice manners, attentive to all questions and problems arriving during the class.— E.G.,The Federal Home Loan Bank of Boston

Awesome instructor. She was very detailed with her explanations and was very helpful in figuring out complex designs. I would highly recommend this course to anyone.— G.C., Stanford Hospital and Clinics

The instructor did a great job keeping the class interesting. He was very patient and hands on. Would definitely take another course by HOTT because I learned a lot in a short period of time. Thank you!— A.A., Respiratory Homecare Solutions

Course Schedule - Face-to-Face in the Classroom or Remote-Live

Choose a city below to view a schedule. If you have any questions, please call us at 978-250-4299 between 9:00 am - 5:00 pm EST.