About this Course
This course provides an introduction Microsoft® SQL Server® Report Builder. In this course, participants will create reports by connecting to a database and manipulate the data for presentation including: creating table and matrix reports, formatting reports, grouping report data, creating simple and complex expressions, displaying aggregated data, charting data, and preparing reports for printing and exporting. Report Builder is available in all supported versions of Microsoft® SQL Server® (2016, 2014, 2012, and 2008R2).
The primary audience for this course are persons who are new to reporting with Microsoft® SQL Server® Report Builder and SSRS, persons who are transitioning from another reporting software application, and persons who are existing Report Builder and SSRS report authors. The secondary audience for this course are persons who are using Report Designer (SSRS). Persons may be business analysts, program analysts, data analysts, database administrators, or IT professionals. Course participants may or may not have experience with Microsoft® SQL Server® Report Builder and SSRS, programming (Visual Basic), and/or Transact-Structured Query Language (T-SQL) experience.
After completing this course, students will be able to:
• Create parameter reports.
• Create list reports.
• Work with complex expressions.
• Images and Subreports.
• Drilldown and Drillthrough Reports.
• Sparklines, Data Bars, and Indicators.
This course covers the following:
• Parameter Reports
• List Reports
• Complex Expressions
• Images and Subreports
• Drilldown and Drillthrough Reports
• Sparklines, Data Bars, and Indicators
Length of Class:
Instructor-led or Online: