Back to training page

Introduction to SQL Reporting Services for SDE

Introduction to SQL Reporting Services for SDE
This two (2) day course is intended to introduce the student to SQL Reporting Service basics as it relates to SDE.  At the end of this course  the student will be able to create basic SRSS reports and add those  reports to SDE.
 
Introduction to SQL Reporting

• Overview of SQL Server Reporting Services
• Installing Reporting Services

Creating Basic Reports - Fundamentals

• Understanding SDE Architecture
• Sorting Data
• Graphical Query Designer - Basics
• Formatting Report

Grouping and Sorting

• Creating Groups
• Connecting to database and selecting Tables/Views
• Grouping and Sorting

Calculating Totals and Other Aggregates

• Adding Totals
• Understanding Scope
• Specifying Aggregate Calculations

Manipulating Data Sets

• Defining Report Data
• Using Parameters and Filters
• Using Parameter Lists

Publishing and Executing Reports

• Executing Reports