The two-day course allows students to continue learning the foundations of writing reports using SSRS and Report Designer of SQL Server.
Course Price : $1150 Per Participant
The two-day course allows students to continue learning the foundations of writing reports using SSRS and Report Designer of SQL Server.
The focus is given on connecting to a database to create reports and manipulate presentation data such as parameter report creation, list reports creation, the addition of complex expression in reports, adding drill through and drill down functions, adding sub reports and images, and adding data bars, sparklines, and indicators within the reports.
This training is designed based on the objectives of the course variant 55170A.
Courses
Years of Experience
Global Learners
The key audience for the course is individuals new to the reporting environment using SSRS or Report Designer of SQL Server, users shifting from other reporting software, and people who are currently Report builders and are report authors of SSRS.
The other audience group who can take this course is the existing Report Builders (SSRS).
The participants of the course could be Business Analysts, data analysts, programmer analysts, database admins, and IT workers with possible but not mandatory hands-on experience with SSRS or Report Builder, Visual Basics, and T-SQL.
Microtek Learning is a Microsoft Certified Partner for Learning Solutions. This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).
This module introduces the use of the parameter in report writing. Parameters allow a level of self-service reporting wherein the report audience can choose the data to view (date range, department, geography, etc.).
Lab: Creating Parameterized Reports
After completing this module, students will be able to:
This module introduces the list data region. List data regions allow report writers free-form control over their reports, whereas, table and matrix reports bind you to a table or matrix data presentation. This free-form feature affords the report writer the ability to truly customize the report.
Lab: Creating List Reports
After completing this module, students will be able to:
This module introduces several new report formatting techniques which allow the report writer better control over the data displayed in the report.
Lab: Enhancing Reports with Complex Expressions
After completing this module, students will be able to:
In this module, students will add images and reports (subreports) to reports, tour and students will be introduced to SSRS (SQL Server Reporting Services).
Lab: Working With Images and Subreports
After completing this module, students will be able to:
This module introduces the ToggleByItem and Action properties to incorporate drilldowns and drillthrough reporting.
Lab: Add Drilldown and Drillthrough Functionality to Reports
After completing this module, students will be able to:
This module introduces the ability to create and add charts to reports. Whether through wizard or individual effort, chart reports or charts as report components allow us to visualize data with or without the details.
Lab: Adding Sparklines, Data Bars, and Indicators to Reports
After completing this module, students will be able to:
©2023 Microtek Learning – All Rights Reserved