50405 - Microsoft SQL Server 2005 Report Builder

Summary

This one day course is intended for users who will be creating their own reports using SQL Server Report Builder. This course covers how to use the SQL Server Report Builder tool to create customized reports based on data stored in a database. The course covers how to identify the data to display in a report, add totals, format fields, and prompt users for values. No knowledge of SQL is required for this course.

Pre-requisites

None

OUTLINE

CHAPTER 1 WHY USE REPORT BUILDER

At the end of this chapter you will be able to:

• Explain how Report Builder fits in to Business Intelligence
• Identify the different components of a Reporting Solution
• Explain the concept of a Data Source, Data Source View, and Data Model
• Create a simple data model

CHAPTER 2 CREATE A SIMPLE REPORT

At the end of this chapter you will be able to:

• Launch Report Builder
• Select a model for a report
• Select a template for a report
• Select entities and attributes to display on a report
• Preview a report
• Filter data in a report using filter conditions
• Save a report

CHAPTER 3 REPORT LAYOUTS

At the end of this chapter you will be able to:

• Create a report with a table layout with one or more groups
• Create a matrix report
• Create a chart report
• Format the data, titles, and labels on a chart report
• Sort the data on your report
• Add totals to a report

CHAPTER 4 FORMATTING YOUR REPORT

At the end of this chapter you will be able to:

• Create calculated fields based on formulas
• Change the appearance of fields on your report
• Format numeric and date values
• Add report headers and footers

CHAPTER 5 CONTROLLING THE USER EXPERIENCE

At the end of this chapter you will be able to:

• Create drill through reports
• Prompt users for values that affect report output