Crystal Reports XI: Advanced

Crystal Reports XI:
Advanced

Topic-Level Outline

�� Days:� 2

�� Prerequisites:� Crystal Reports XI: Basic

�� Unit 1 :� Selecting data

�� Topic A: 0� Parameter fields

�� A-1:�� Creating a parameter field

�� A-2:�� Using wildcards to select data

�� A-3:�� Applying an edit mask to a parameter

�� Topic B: 0� Defining report elements

�� B-1:�� Using a pick list in a parameter field

�� B-2:�� Modifying a pick list to allow multiple values

�� B-3:�� Using a date range

�� B-4:�� Creating a cascading parameter

�� Unit 2 :� Advanced formulas and functions

�� Topic A: 0� Running totals

�� A-1:�� Creating a running total

�� A-2:�� Modifying a running total

�� A-3:�� Resetting a running total based on a group

�� Topic B: 0� Variables

�� B-1:�� Declaring and using a variable in a formula

�� B-2:�� Using an array variable in a formula

�� B-3:�� Using a range variable in a formula

�� Topic C: 0� Advanced functions

�� C-1:�� Creating a formula by using multiple functions

�� C-2:�� Using the EvaluateAfter function

�� Topic D: 0� Constructs

�� D-1:�� Using a For construct

�� D-2:�� Using a While construct

�� Unit 3 :� Charts and maps

�� Topic A: 0� Working with charts

�� A-1:�� Creating a chart

�� A-2:�� Modifying a chart

�� A-3:�� Creating a funnel chart

�� Topic B: 0� Creating maps

�� B-1:�� Creating a map by using the Map Expert

�� B-2:�� Customizing a map

�� Unit 4 :� Formatting complex reports

�� Topic A: 0� The Section Expert

�� A-1:�� Modifying section properties

�� A-2:�� Adding new sections

�� A-3:�� Underlaying a section containing a chart

�� A-4:�� Displaying groups on separate pages

�� A-5:�� Merging report sections

�� A-6:�� Deleting a section

�� Topic B: 0� Advanced conditional formatting

�� B-1:�� Using a formula to change a font conditionally

�� B-2:�� Suppressing page numbering on first page only

�� B-3:�� Conditionally formatting a section background color

�� B-4:�� Using parameters to conditionally format background color

�� B-5:�� Creating a conditional format for grouped data

�� Topic C: 0� Objects

�� C-1:�� Adding a hyperlink

�� C-2:�� Adding a linked OLE object

�� Unit 5 :� Alerts and subreports

�� Topic A: 0� Report alerts

�� A-1:�� Creating a report alert

�� A-2:�� Modifying a report alert

�� A-3:�� Deleting a report alert

�� Topic B: 0� Subreports

�� B-1:�� Creating an unlinked subreport

�� B-2:�� Creating a linked subreport

�� B-3:�� Creating an on-demand subreport

�� B-4:�� Creating a caption for an on-demand subreport

�� Unit 6 :� Data management features

�� Topic A: 0� The Business Objects Enterprise Repository

�� A-1:�� Adding an item

�� A-2:�� Using a repository item in a report

�� A-3:�� Modifying an item

�� A-4:�� Deleting an item

�� Topic B: 0� The Workbench

�� B-1:�� Creating a new project in the Workbench

�� Unit 7 :� Advanced data access techniques

�� Topic A: 0� ODBC data sources

�� A-1:�� Discussing ODBC data sources

�� A-2:�� Making ODBC source settings

�� A-3:�� Creating a report using an ODBC data source and an Access database

�� Topic B: 0� SQL and the Database Expert

�� B-1:�� Understanding SQL syntax

�� B-2:�� Creating a command while creating a report

�� B-3:�� Editing a command

�� B-4:�� Adding a command to the repository

�� B-5:�� Creating a report based on an existing query