CTE Solutions chair
Quick Search:  
Course No.  
FacebookTwitterLinkedInYouTube
Savings

Got A Question?
Talk to an Educational Consultant and get the answers you need.

By Phone
Ottawa: 613-798-5353
Toronto: 416-284-2700
Toll Free: 866-635-5353

right arrow Ask your question online

50405 - Microsoft SQL Server 2005 Report Builder

Summary


Microsoft Gold Certified Partner for Learning SolutionsThis 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

      3 Ways to Register
$495.00
$420.75 CAD
online only

1 (866) 635-5353
sales@ctesolutions.com
Ask About This Course

  Latest Tweet


About This Course
Certifications