SQL
$1185
Per Participant
Students will continue to study the fundamentals of report writing using SSRS and Microsoft® SQL Server® Report Builder in this two-day course. This course focuses on constructing parameter reports, custom reports utilizing the list data region, complicated expressions for formatting and analysis, images and subreports added to reports, drill-down and drill-through features created, and sparklines, data bars, and indicators added to reports. All supported versions of Microsoft SQL Server are compatible with Report Builder, and this course can be used with any of those versions.
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.).
Lessons
Lab 1: 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.
Lessons
Lab 1: 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.
Lessons
Lab 1: 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).
Lessons
Lab 1: 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.
Lessons
Lab 1: 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.
Lessons
Lab 1: Adding Sparklines, Data Bars, and Indicators to Reports
After completing this module, students will be able to:
For many years, Microtek Learning has been helping organizations, leaders, and professionals to reach their maximum performance by addressing the challenges they are facing.
Share With Your Friends!
Twitter
LinkedIn