Report Builder 3 can be used to create reports for SQL Server 2008 R2, 2012 and 2014.

This course provides the skills for delegates to create reports using Report Builder 3

Course Outline

•  Introduction
  • What it looks like.
  • Where everything is.
  • How easy it is to create reports.
• Connecting to Data
  • Types of data sources.
  • Shared Data Sources.
  • Report specific data sources.
  • Data source credentials.
• Retrieving Data
  • Data Sets.
  • Query Designer.
  • Stored Procedures.
• Designing Reports
  • Report and page properties
  • Headers & Footers.
  • Data regions.
  • Matrices.
  • Lists.
  • Charts.
  • Gauges.
  • Maps.
  • Other Report Items.
  • Text boxes.
  • Sub reports.
  • Formatting report items.
• Manipulating Data Sets
  • Sorting data.
  • Grouping Data.
  • Using parameters with your data.
  • Creating and using parameters in your data.
  • Setting default values for parameters.
  • Creating parameter lists.
  • Calculations.
  • Filters.
• Enhancing Basic Reports
  • Report item visibility.
  • Interactive sorting.
  • Expressions.
  • To display report information & parameters values.
  • To highlight exceptions in data.
  • To stripe data rows.
  • Document maps.
• Saving, Sharing and Printing Reports
  • Saving local reports.
  • Sharing reports.
  • To a report server.
  • To a SharePoint site.
  • Viewing, printing and exporting reports from a report server or SharePoint.
  • Creating report subscriptions

Duration

• This course can be completed in 2 days just using examples from the sample Adventure Works Database.
• By extending it to 3 days, delegates can practice their skills using their own data