Unit 1: Selecting data

 Topic A: Parameter fields

·          Creating a parameter field

·          Using wildcards to select data

·          Applying an edit mask to a parameter

 Topic B: Defining report elements

·          Using a pick list in a parameter field

·          Modifying a pick list to allow multiple values

·          Using a date range

·          Creating a cascading parameter

 Unit 2: Advanced formulas and functions

 Topic A: Running totals

·          Creating a running total

·          Modifying a running total

·          Resetting a running total based on a group

 Topic B: Variables

·          Declaring and using a variable in a formula

·          Using an array variable in a formula

·          Using a range variable in a formula

 Topic C: Advanced functions

·          Creating a formula by using multiple functions

·          Using the EvaluateAfter function

 Topic D: Constructs

·          Using a For construct

·          Using a While construct

 Unit 3: Charts and maps

 Topic A: Working with charts

·          Creating a chart

·          Modifying a chart

·          Creating a funnel chart

 Topic B: Creating maps

·          Creating a map by using the Map Expert

·          Customizing a map

 Unit 4: Formatting complex reports

 Topic A: The Section Expert

·          Modifying section properties

·          Adding new sections

·          Underlaying a section containing a chart

·          Displaying groups on separate pages

·          Merging report sections

·          Deleting a section

 Topic B: Advanced conditional formatting

·          Using a formula to change a font conditionally

·          Suppressing page numbering on first page only

·          Conditionally formatting a section background color

·          Using parameters to conditionally format background color

·          Creating a conditional format for grouped data

 Topic C: Objects

·          Adding a hyperlink

·          Adding a linked OLE object

 Unit 5 : Alerts and subreports

 Topic A: Report alerts

·          Creating a report alert

·          Modifying a report alert

·          Deleting a report alert

 Topic B: Subreports

·          Creating an unlinked subreport

·          Creating a linked subreport

·          Creating an on-demand subreport

·          Creating a caption for an on-demand subreport

 Unit 6: Data management features

 Topic A: The Business Objects Enterprise Repository

·          Adding an item

·          Using a repository item in a report

·          Modifying an item

·          Deleting an item

 Topic B: The Workbench

·          Creating a new project in the Workbench

 Unit 7: Advanced data access techniques

 Topic A: ODBC data sources

·          Discussing ODBC data sources

·          Making ODBC source settings

·          Creating a report using an ODBC data source and an

       Access database

 Topic B: SQL and the Database Expert

·          Understanding SQL syntax

·          Creating a command while creating a report

·          Editing a command

·          Adding a command to the repository

·          Creating a report based on an existing query