Publisher: Microsoft

Version: 2005/8
Length: 1 day
Course-ID: SX686GRB

Course Overview

SQL Server 2005/20088 Report Builder 2.0 provides a versatile and powerful reporting platform for data on Microsoft SQL Server 2005/2008. In this course, you learn how to extract business intelligence from your data. In addition, you gain the knowledge and skills to produce compelling visual reports and deliver those reports.

Course Objective

Target student

Anyone designing, creating or delivering reports from relational databases with SQL Server 2005/2008 Report Builder 2.0.

Prerequisites

Previous exposure to any database system or spreadsheet data is assumed.


Creating a new report
  • Adding a Report Title
  • Saving the report on the Report Server
  • Previewing the Report
  • Adding a Table
  • Defining a T-SQL query for the report data
  • Organising data into groups
  • Adding Subtotals and Totals
  • Specifying a table Style
Formatting a Report
  • Format the Currency
  • Change Column Widths
Adding a Column Chart to Your Report
  • Moving the legend
  • Change the chart title
  • Format as currency the numbers on the vertical axis
  • Changing the axis labels
  • Adding a moving average
  • Save the report
Adding Parameters
  • Changing the dataset query to accept Parameters
  • Changing the data type and default values of a report parameter
  • Setting default values for parameters
  • Adding a new field to the query to use for filtering
  • Adding a new report parameter
  • Adding Parameters to Create a List of Available Values
  • Populating a static list for a report parameter
  • Populating a dynamic list for a report parameter
Creating a new report definition file and saving it on the report server
  • Adding a data source reference
  • Creating the main dataset with a query and query parameters
  • Setting date parameter data types and default values
Adding Parameters to Pass to a Drillthrough Report
  • Launch the table wizard and add a connection
  • Adding a report drillthrough action to your report
Adding a KPI to Your Report
  • Displaying the present state of a KPI by using background colors
  • Displaying the present state of a KPI using a gauge
Adding a Pie Chart to Your Report
  • A dding a pie chart with the Chart wizard
  • Displaying percentages in each slice of the pie chart
  • Combining any slices on the pie chart smaller than 5 percent into one slice
  • A dding a drawing effect to the pie chart
Adding a Bar Chart to Your Report
  • A dding a bar chart with the Chart wizard
  • Filtering the top five values on the bar chart
  • Sorting the names in alphabetical order on the bar chart