Log On/Register  

855.838.5028

Crystal Reports 2011 - Level 2

Duration: 2 Days
Course Price: $895

Course Objective

You will connect to a database to extract data and present it as a report.

Target Student

This course is designed for people who need output from a database. In some cases, database programs have limited reporting tools, or such tools may not be accessible. Students may or may not have programming or SQL experience.

Course Objectives

Upon successful completion of this course, students will be able to:Creating more dynamic reports using Parameter fields.

  • Creating more advanced report formulas and functions using variables and Running Totals.
  • Graphing data using Charts; graphing geographic data using Maps.
  • Formatting and controlling various sections of a report using the Section Expert.
  • Applying more advanced report formatting by writing Conditional Formatting formulas.
  • Creating report Alerts.
  • Adding a Sub-report to a main report.
  • Data management features including the Workbench tool and the Business Objects Enterprise Repository.
  • Overview of ODBC data sources and use of SQL in Crystal Reports.

Course Objective

You will connect to a database to extract data and present it as a report.

Target Student

This course is designed for people who need output from a database. In some cases, database programs have limited reporting tools, or such tools may not be accessible. Students may or may not have programming or SQL experience.

Course Objectives

Upon successful completion of this course, students will be able to:Creating more dynamic reports using Parameter fields.

  • Creating more advanced report formulas and functions using variables and Running Totals.
  • Graphing data using Charts; graphing geographic data using Maps.
  • Formatting and controlling various sections of a report using the Section Expert.
  • Applying more advanced report formatting by writing Conditional Formatting formulas.
  • Creating report Alerts.
  • Adding a Sub-report to a main report.
  • Data management features including the Workbench tool and the Business Objects Enterprise Repository.
  • Overview of ODBC data sources and use of SQL in Crystal Reports.

Prerequisites

Before taking this course, students should be familiar with the basic functions such as creating and navigating folders, opening programs, manipulating windows, copying and pasting objects, formatting text, and saving files in Microsoft® Windows®. In addition, students should have taken the Microsoft® Office Access 2010: Level 1 course or have equivalent experience with basic database concepts.

This builds on the skills and concepts taught in Crystal Reports XI: Basic. 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.

Module 1: Selecting data

  • Parameter fields
  • Defining report elements

Module 2: Advanced formulas and functions

  • Running totals
  • Variables
  • Advanced functions
  • Constructs

Module 3: Charts and maps

  • Working with charts
  • Creating maps

Module 4: Formatting complex reports

  • The Section Expert
  • Advanced conditional formatting
  • Objects

Module 5 : Alerts and subreports

  • Report alerts
  • Subreports

Module 6: Data management features

  • The Business Objects Enterprise Repository
  • The Workbench

Module 7: Advanced data access techniques

  • ODBC data sources
  • SQL and the Database Expert
Learn More
Please type the letters below so we know you are not a robot (upper or lower case):