Crystal Reports 11: Level 2
Class Outline:
Description:
This course builds on the skills and concepts taught in Crystal Reports XI: Level 1. Students will learn how to create and use parameter fields, including 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, apply advanced formatting options to report elements, and create alerts and subreports. Finally, students will work with the Business Objects Enterprise Repository and the Workbench, and they will learn advanced data access techniques including ODBC data sources and SQL query-building.
Table of Contents:
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: SQL and the Database Expert
Objectives:
-Create and use parameter fields; use an Edit Mask; and select data by using a pick list, a date range, and cascading parameters.
-Create and modify running totals; use variables, arrays, and ranges in a formula; use multiple functions, and Evaluation Time functions in a formula; and use For and While constructs in a formula.
-Create and customize charts and maps.
-Modify, add, merge, and delete report sections in a report; apply advanced conditional formatting techniques to report objects; and add hyperlinks and OLE objects to a report.
-Create, modify, and delete report alerts; and create and use unlinked, linked, and on-demand subreports.
-Add items to the Business Objects Enterprise Repository; modify and delete items from the repository; and manage report projects by using the Workbench.
-Use ODBC to access data from different types of data sources; create SQL commands (queries) while creating reports, modify commands using the Database Expert; and create reports based on existing queries.