SQL Server 2012
Reporting Services
Overview
Course Objective
After completing this course, the participants will be able to work with solutions and projects such as:
• Design basic reports
• Work with table, matrix, and list report items
• Enhance reports with formatting and images
• Effectively group and summarise data
• Work with parameterised reports
• Incorporate charts and custom maps
• Work with drill-through reports
• Manage reports
• Utilise Report Builder
Who Should Attend
Prerequisites
Training Calendar
Intake
Duration
Program Fees
Module
Module 1 - SRSS Overview and Tools
• Reporting Services Features
• Tools Available with SQL Server 2012
• SQL Server Documentation
• Understand Reporting Services Features
• Identify the SQL Server 2012 Tools
• Find and Use SQL Server Documentation
Module 2 - Working with Solutions and Projects
• Working with SQL Server Data Tools
• Understanding Solutions and Projects
• Working with the Visual Studio Interface
• Lab: Working with Solutions and Projects (Optional)
• Work with SQL Server Data Tools
• Understand solutions and projects
• Work with the Visual Studio interface
Module 3 - Creating Basic Reports
• What is a Data Source?
• What is a Dataset?
• Using the Report Wizard
• What is Tablix?
• Creating a Tabular Report
• Creating a List Report
• What is a Matrix?
• Deploying a Project
• Lab: Creating Basic Reports
• Understand the differences between shared and embedded data
sources and datasets
• Create shared and embedded data sources and datasets
• Use the Report Wizard to build basic reports
• Create a basic matrix report from a shared dataset
Module 4 - Formatting Reports
• Working with Text Boxes
• Rich Text Formatting
• Managing Text Boxes
• Drawing Lines and Boxes
• Images
• Page Headers and Footers
• Adding a Document Map
• Rendering Reports
• Lab: Formatting Reports
• Format data to enhance a report
• Add images to a report
• Work with page headers and footers
Module 5 - Custom Expressions
• Understanding Expressions
• Defining Expressions
• Working with Report Variables
• Understanding Lookup, LookupSet, and Multilookup Functions
• Expression Samples
• Lab: Custom Expressions
• Use expressions to work with custom formulas
• Use expressions to change the way data is displayed in report
• Use expressions to incorporate data from more than one dataset
Module 6 - Summarising and Sorting
• Creating Groups
• Parent/Child vs. Adjacent Groupings
• Adding Totals and Aggregations
• Creating Aggregates of Aggregates
• Lab: Summarising and Sorting
• Add both row and column parent groups to an existing report
• Aggregate data for summary reports
• Create reports using adjacent groups in a matrix
• Work with group properties
Module 7 - Add Flexibility with Parameters
• Adding Parameters to a Report
• Report Parameters vs. Query Parameters
• Manage Report Parameter Properties
• Use Parameters with SQL Queries and Stored Procedures
• Work with Cascading Parameters
• Sort Based on a Parameter Setting
• Filtered Reports
• Lab: Add Flexibility with Parameters
• Customise report data with both query and report parameters
• Use parameters to define interactive sort and visibility options
• Add filters to a dataset
Module 8 - Enhanced Report Items
• Charts
• Gauges
• Add a Map to a Report
• Data Bar, Indicator, and Sparkline Report Items
• Nesting Data Regions
• Sub-reports and Drill-through Reports
• Working with Drill-through Reports
• Lab: Enhanced Report Items
• Use lessons up to this point to create a complete solution
• Choose between data visualisation options
• Add data visualisation items to an existing report
• Add a drill-through report send parameters to the drill-through
report
Module 9 - Using Report Manager
• Deployment
• Navigating Report Manager
• Understanding Permissions
• Viewing Reports
• Working with Shared Data Sources
• Managing Reports
• Lab: Using Report Manager
• Create and deploy a project by using SSDT
• Work with Report Manager to view and manage reports
• Create a linked report
• Add report snapshots by using Report Manager
Module 10 - Using Report Builder for SQL Server 2012
• ClickOnce vs. Stand-alone
• Installing the Stand-alone Version
• Using the Report Builder Tool
• Creating Datasets
• Creating Reports
• Creating Reports Using Wizards
• Creating Reports Without a Wizard
• OPening Existing Reports
• Working with Report Parts
• Lab: Using Report Builder for SQL Server 2012
• Implement basic features from previous modules in Report
• Builder
• Add data visualisation items to a report using Report Builder
FAQs
General Questions:
Q: What is the 55119A – SQL Server 2012 Reporting Services course about?
A: This three-day course teaches participants how to design, build, and manage reports using SQL Server 2012 Reporting Services (SSRS). It covers Report Designer in SSDT and Report Builder, working with solutions and projects, designing reports, formatting, grouping data, using parameters, incorporating charts and maps, and managing reports. Hands-on labs reinforce practical skills.
Q: Who should attend this course?
A: This course is intended for information workers and database professionals who have a general familiarity with databases. A working knowledge of Microsoft SQL Server or Microsoft Office applications is beneficial.
Q: What are the prerequisites for this course?
A: Participants should have a basic understanding of databases. Prior experience with Microsoft SQL Server or Microsoft Office applications is helpful but not required.
Q: How long is the course?
A: The course duration is 3 days.
Q: What key topics are covered in this course?
A: Topics include:
Overview of SQL Server Reporting Services (SSRS) and available tools
Working with SQL Server Data Tools (SSDT) and Visual Studio
Creating and formatting reports using tables, matrices, and lists
Using custom expressions, grouping, sorting, and aggregating data
Adding report parameters for flexibility
Enhancing reports with charts, gauges, maps, and drill-through reports
Managing and deploying reports using Report Manager
Utilizing Report Builder for report creation
Q: Will I receive a certification after completing the course?
A: This course builds hands-on skills in SQL Server 2012 Reporting Services but does not provide certification.
Program Content & Skills:
Q: What are the key modules covered in the 55119A – SQL Server 2012 Reporting Services course?
A: The course includes modules on the following topics:
SRSS Overview and Tools – Understanding Reporting Services features and SQL Server 2012 tools.
Working with Solutions and Projects – Using SQL Server Data Tools (SSDT) and Visual Studio interface.
Creating Basic Reports – Working with data sources, datasets, Tablix, and report deployment.
Formatting Reports – Enhancing reports with text, images, headers, and footers.
Custom Expressions – Using expressions, variables, and lookup functions to manipulate data.
Summarizing and Sorting – Grouping data, adding totals, and creating summary reports.
Adding Flexibility with Parameters – Implementing query and report parameters for customization.
Enhanced Report Items – Using charts, gauges, maps, data bars, and drill-through reports.
Using Report Manager – Managing, deploying, and viewing reports through Report Manager.
Using Report Builder – Creating datasets, reports, and working with Report Parts.
Q: What specific skills will I gain after completing the course?
A: After completing the course, you will have skills in:
Designing and deploying reports using SSDT and Report Builder
Creating and formatting reports with tables, matrices, and lists
Implementing data grouping, summarization, and sorting techniques
Adding interactivity with parameters and drill-through reports
Enhancing reports with visual elements like charts, maps, and gauges
Managing and deploying reports using Report Manager
Utilizing Report Builder for ad-hoc report creation
Q: Does the course include practical labs or hands-on exercises?
A: Yes, the course includes hands-on labs that allow participants to apply concepts in real-world scenarios, such as designing reports, configuring data sources, creating visual elements, and managing reports using Report Manager.
Q: What will I learn about summarizing and sorting data?
A: In the Summarizing and Sorting module, you will learn how to create and manage groups, apply totals and aggregations, and build matrix reports using adjacent groupings.
Q: What is covered under report parameters and filtering?
A: The Add Flexibility with Parameters module covers adding report and query parameters, managing parameter properties, creating cascading parameters, and filtering data dynamically.
Q: How will the course help with report deployment and management?
A: The Using Report Manager module will teach you how to deploy projects, navigate Report Manager, manage permissions, create snapshots, and work with shared data sources for efficient report administration.
Q: Can I use Report Builder after completing the course?
A: Yes, you will learn how to use Report Builder to create reports, datasets, and report parts, as well as work with wizards and custom visualization elements.
Q: Is there a focus on data visualization techniques?
A: Yes, the Enhanced Report Items module covers adding charts, gauges, maps, and drill-through reports to improve report clarity and user interaction.
Submit your interest today !
