Report Builder 3 Training Course

Who should attend

The course is designed for experienced Excel, Access and other Relational Database users wanting to create reports for use with Microsoft Reporting Services without using BIDS.

Prerequisites

Delegates should ideally have a good degree of experience manipulating and presenting data within Microsoft Excel and / or Microsoft Access. Practical knowledge of SQL would be useful too. Other equivalent Relational Database experience (such as Oracle, MySQL) should also be sufficient.

On-site

If you would like to find out about custom / on-site Report Builder 3 training for any size of team, please get in touch – we would be glad to help build a course that meets your learning requirements.

We can take into account your existing technical skills, project requirements and timeframes, and specific topics of interest to tailor the most relevant and focussed course for you.

This can be particularly useful if you need to learn just the new features and Best Practices with Reoprt Builder 3 if you're coming from an earlier version, or need to include extra topics to help with prerequisite skills.

Report Builder 3 Training Course

Introduction to Report Builder 3

• Getting to know Report Builder
• Overview of tools and functions

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 and 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
• Display Report information and parameters
• Values
• Highlighting 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