Upon Request Courses

Report Builder 3.0

This course is designed for individuals new to Report Builder 3.0. Participants will learn to create reports, sort and select data, group and summarize, create formula fields, use wizards and print and export reports.

Dates & Times

Request

Call (518) 786-1181 or contact us for customized, individual or group training.

Course Outline

Corporate and NYS discounts do not apply for this course.

The course is appropriate for new users of SQL Reporting Services, Report Builder 3.0 or those who want to learn the application from the ground up.

Includes:
Comprehensive reference manual with participant guide and exercises
Access to participant data files
Follow-up support by email or phone for an unlimited period

Lesson 1: Getting started

  • Exploring the Interface
  • Reviewing the Ribbon
  • Adding a Data Source

Lesson 2: Adding a Dataset using SQL

  • Adding a Dataset by Importing
  • Adding a Dataset using a SQL Procedure
  • Adding a Dataset using the Query Designer
  • Creating Table Links
  • Filtering Data

Lesson 3: Formatting reports

  • Adding a Report Title
  • Changing Page Layout Options
  • Moving and sizing objects
  • Formatting objects
  • Saving reports

Lesson 4: Creating a Report

  • Adding a Table/Matrix
  • Adding Fields
  • Formatting Report
  • Inserting lines, boxes, and text objects

Lesson 5: Sorting and Grouping

  • Grouping and Sorting Data
  • Inserting Page Breaks
  • Grouping Data
  • Summarizing Data

Lesson 6: Working with charts

  • Selecting the appropriate chart
  • Creating a chart
  • Examining chart properties
  • Including Sparklines, Databars and Indicators
  • Formatting charts

Lesson 7: Finalizing a Report

  • Publishing a Report to the Report Manager
  • Adding a Report Description
  • Open a Report from the Report Manager