Pre/Post Conference Academy

Pre/Post Conference Academy

Academy - SSRS Building Reports I & II

Monday, March 19
8:00 AM - 12:00 PM
Room: Biology

Format: Pre/Post Conference Academy

This interactive LAB based class is intended to teach administrators, power users, and managers how to build SQL Server Reporting Services reports.

Participants will learn how to create functioning reports that utilize filters, parameters, sub-reports, graphs and charts. They also will learn more advanced SSRS Report building techniques and features. We will introduce the Power BI / SSRS relationship and show what is possible.

SSRS Report Builder
• Installation
• Functions and uses
• Report Types & Uses

Report Filters
• Report filtering
• Query Parameters

Report Data Regions
• Table
• Matrices
• Lists

Report Security
• Report Level
• Folder Level
• Active Directory Connections

Graphs / Charts
• Indicators
• Embedded Charts

Report Filters (Adv)
• Active Directory Relationships
• Dynamics GP Relationships

Report Types
• Linked Reports
• Snapshot Reports
• Click through Reports
• Drill Down/Through

SSRS Portal
• 2016/17 feature
• Custom Branding
• KPI’s / Dashboard
• Home Portal Designs for each user

Graphs / Charts
• Tree Maps
• Sunbursts

Power BI
• Basic requirements
• Configuration / Setup
• Pinning SSRS Reports

• Kerry Hataley - Nanook Software

• SQL Programmers
• IT Professionals
• Dynamics Data / Report Professionals
• Power Users

• Beginner & Intermediate

• None

• User need to have computer that is able to connect to the internet
• Be on time and ready to learn and ask questions

Delivery Method
• Class Room with LAB’s

o Lecture Time = 65%
o LAB Time = 35%

o Morning (8:00 - 12:00) + 15 min break
o Afternoon (1:00 - 5:00) + 15 min break

Learning Objectives:

Kerry Hataley

Nanook Software

Kerry Hataley is an Independent Dynamics GP Consultant. Kerry has been working with Dynamics GP since 1994 starting with version 2.0 – on the Macintosh. Kerry loves all things SQL. He specializes in Dynamics GP data corrections along with Project Accounting, Fixed Assets, Canadian Payroll, Inventory, Accounts Payable and Cogsdale CSM. Since attending Convergence #1 in 1997 with 167 of his other GP users (mainly accountants) he has witnessed Great Plains grow and mature into Dynamics GP that we love today. In Kerry’s spare time he loves to travel and spend time working on renovations and home projects.

Kerry is deeply passionate about SQL Server and SQL Server Reporting Services. His 30+ years of experience in the database worls allows him to walk the talk and as the current 2017 GPUG Summit SQWL Shootout Champ - has proved it.


Send Email for Kerry Hataley


Academy - SSRS Building Reports I & II

Attendees who have favorited this

Send Email for Academy - SSRS Building Reports I & II