16 Corporate Woods Boulevard | Albany, New York 12211 | Tel: 518.437.1600

Crystal Reports: Level 2

Available Dates: July 27, Aug 21, Sept 19, Oct 18, Nov 16, Dec 28
Class Length: 1 day
Cost: $399

Class Outline:

This course will build on the skills learned in Crystal Reports: Basic. Students will learn how to create and use parameter fields, including interactive and cascading parameters. They will learn how to build advanced formulas using variables, advanced functions, and constructs. They will also learn how to create and customize charts and maps, how to apply advanced formatting options to report elements, and how to create alerts and subreports. They will learn about the Business Objects Enterprise Repository. Finally, students will learn advanced data access techniques including ODBC data sources and SQL query-building.

Unit 1: Selecting data
Topic A: Parameter fields
Topic B: Defining report elements

Unit 2: Advanced formulas and functions
Topic A: Running totals
Topic B: Variables
Topic C: Advanced functions
Topic D: Constructs

Unit 3: Charts and maps
Topic A: Working with charts
Topic B: Creating maps

Unit 4: Formatting complex reports
Topic A: The Section Expert
Topic B: Advanced conditional formatting
Topic C: Objects

Unit 5 : Alerts and subreports
Topic A: Report alerts
Topic B: Subreports

Unit 6 : Data management features
Topic A: The Business Objects Enterprise Repository
Topic B: The Workbench

Unit 7: Advanced data access techniques
Topic A: ODBC data sources
Topic B: The Business Objects Enterprise Repository
Topic C: SQL and the Database Expert