SQL Server Reporting Services (Crash Course)
This is a one day class.
Target Student:
This one day instructor-led course covers the basics of SQL Server Reporting Services. Lessons cover report setup, formatting and execution methods. Installation and administrative topics are NOT covered in this course. We will get you started building reports, primarily using Report Builder, since we think Report Builder is the easiest reporting tool to use with SSRS.
This is a good course for an non-IT person who needs to build reports but doesn't need to know all the ins and outs of installing or administering Reporting Services.
Course outline:
Lesson 1: Introduction to Microsoft SQL Server Reporting Services
Topic 1A: Overview of SQL Server Reporting Services
Lesson 2: Authoring Basic Reports
Topic 2A: Creating a Basic Table Report
Topic 2B: Formatting Report Pages
Topic 2C: Calculating Values
Lesson 3: Enhancing Basic Reports
Topic 3A: Interactive Navigation
Topic 3B: Displaying Data
Lesson 4: Manipulating Data Sets
Topic 4A: Defining Report Data
Topic 4B: Using Parameters and Filters
Lesson 5: Publishing and Executing Reports
Topic 5A: Publishing Reports
Topic 5B: Executing Reports