Creating Reports Using Report Builder 3.0

Request info

Report Builder Training 

This course is an introduction to creating reports using Report Builder 3.0. It is designed for experienced Excel or Access users wanting to create reports for use with Microsoft Reporting Services, which is a component of Microsoft SQL Server.

A Report can only be created when the appropriate data is available, so the course also includes accessing data using Transact SQL statements, as well as the graphical tools

1. Introduction

• What it looks like.
• Where everything is.
• How easy it is to create reports.

2. Connecting to Data

• Types of data sources.
• Shared Data Sources.
• Report specific data sources.
• Data source credentials.

3. Retrieving Data

• Data Sets.
• Query Designer.
• Stored Procedures.

4. 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.

5. 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.

6. 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.

7. 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
By having this course at your site we are able to create reports using your data, as well as the Adventure Works sample database.

The training involves Instructor led demonstrations, and hands on exercises. There is also time for delegates to create their own reports using their data.

SELECT wp_posts.*, wp_p2p.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_p2p WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'start_date' AND CAST(wp_postmeta.meta_value AS DATE) >= '2024-06-13' ) ) AND ((wp_posts.post_type = 'schedule' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) AND (wp_p2p.p2p_type = 'schedule_to_courses' AND wp_posts.ID = wp_p2p.p2p_from AND wp_p2p.p2p_to IN (SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (4463) AND ((wp_posts.post_type = 'courses' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) ORDER BY wp_posts.post_date DESC )) GROUP BY wp_posts.ID ORDER BY CAST(wp_postmeta.meta_value AS DATE) ASC