55170: Writing Reports with Report Designer and SSRS 2016 Training
Category
SQL Server
Rating
4.5
(4.5)
Price
$1150 Per Participant
Course Description
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.
Who should attend this course?
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 are 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-one experience with SSRS or Report Builder, Visual Basics and T-SQL.
Collaboration with classmates (not available for a self-paced course)
Real-world knowledge activities and scenarios
Exam scheduling support*
Learn and earn program*
Practice Tests
Knowledge acquisition and exam-oriented
Interactive online course.
Support from an approved expert
For Government and Private pricing*
* For more details call: +1-800-961-0337 or Email: info@microteklearning.com
Our Clients
For many years, Microtek Learning has been helping organizations, leaders, and professionals to reach their maximum performance by addressing the challenges they are facing.
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.).
Parameterized Reporting
Create Report Parameters
Modify Report Parameters
Provide Default Parameter Values
Provide Available Values for Parameters
Lab: Creating Parameterized Reports
Create Single Value Parameter Reports
Create Multi-Value Parameter Reports
Create an Available Values Parameter Report
Create a Parameter Report with Default Values
Modify Existing Parameter Reports
After completing this module, students will be able to:
Describe the key benefits and features of report parameters.
Create parameterized queries and parameterized reports.
Create parameters which accept single values, multiple values, expose or hide the parameter value, provide a list of available parameter values, and provide parameters with default values.
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.
Introducing the List Data Region
Create Reports Using List Data Regions
Modify Reports Which Use List Data Regions
Lab: Creating List Reports
Create a Multiple Column Report with List Data Regions
Create a Report with Rectangles and Nested Data
Create an Enhanced Report with Rectangles and List Data Regions
After completing this module, students will be able to:
Describe the benefits of list data regions and rectangles in reporting scenarios.
Create reports which display data in multiple columns.
Create reports which take advantage of nested data.
Create enhanced reports using list data regions and rectangles.
In this module, students will add images and reports (subreports) to reports, tour and students will be introduced to SSRS (SQL Server Reporting Services).
Add Images to Reports
Retrieve Images from a Database
Introducing SSRS (SQL Server Reporting Services) Report Server
Add Subreports to Reports
Lab: Working With Images and Subreports
Add an Image to an Existing Report
Display Images from a Database in a Report
Format HTML5 Data to Display Properly in a Report
Use SSRS Report Server to Facilitate Subreporting
Add Subreports to a Report
Add Parameterized Subreports to Reports
After completing this module, students will be able to:
Describe the available options for adding images to reports.
Add images to reports.
Describe the features of SSRS Report Server
Add subreports and parameterized subreports to reports.
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.
Sparklines
Data Bars
Indicators
Lab: Adding Sparklines, Data Bars, and Indicators to Reports
Create Group Charts
Add Indicators and Data Bars to a Report
Add Sparklines to a Report
Add Indicators to a Report
Add Sparklines, Data Bars, and Indicators to a Report
After completing this module, students will be able to:
Describe the key features of incorporating mini-charts and mini-gauges in reports.
Add and modify sparklines, data bars, and indicators in reports.
REVIEWS ON OUR POPULAR COURSES
I was sceptical at first whether to enrol with Microtek Learning or not, however, I am glad that I did- I got everything that was promised (maybe more). The trainer was very patient and knowledgeable and with his effort and mine, I was able to clear the exam with ease! Keep up the good work everyone.
MARTIN
TORONTO, CANADA
(5)
I'm really impressed with the storytelling skills of the instructor. She makes the session exciting by keeping things simple and easy to understand.
Prince N.
Texas
(5)
I was recommended the ITIL 4 Foundation course by an IT professional who had completed the same course at Microtek Learning. The training gave me a thorough understanding of service management that I felt I could take back to my job as an IT Project Management and apply it to improve the value of products and services.
I was sceptical at first whether to enrol with Microtek Learning or not, however, I am glad that I did- I got everything that was promised (maybe more). The trainer was very patient and knowledgeable and with his effort and mine, I was able to clear the exam with ease! Keep up the good work everyone.
MARTIN
TORONTO, CANADA