This course is designed for people who know how to create basic list and group reports but need to create reports that include subreports, cross-tabs, advanced formulas and charts based on more than one data series.

After participating, they will be able to create complex reports using Crystal Reports’ tools.

Course Duration: 2 days
Prerequisites:

Students should participate in Crystal Reports 2011: Level 1 before taking this course. Knowledge of programming and/or SQL is also helpful.

Hardware and Software Requirements:

For this course, you will need one computer for each student and one for the instructor. Each computer will need the following minimum hardware configuration:

  • 1 GHz Pentium®-class processor or faster
  • A minimum of 1 GB of RAM is recommended
  • 20 GB hard disk or larger if you use Windows XP Professional as your operating system. You should have at least 1 GB of free hard disk space available for Office 2010 installation
  • Access to one of the following: a local CD-ROM drive, a local DVD drive, or access to a networked CD-ROM drive
  • A keyboard and mouse or other pointing device
  • A 1024 x 768 resolution SVGA monitor is recommended
  • Network cards and cabling for local network access
    Internet access (check with your local network administrator).
  • A printer (optional) or an installed printer driver
  • A projection system to display the instructor’s computer screen

 

Each computer requires the following software:

  • Microsoft® Windows® XP SP2 or Vista
  • Custom installation of Crystal Reports® 2011
  • Default installation of Microsoft® Office 2010
  • Printer driver (Printers are not required; however, each PC must have an installed printer driver to use Print Preview.)
  • Adobe® Reader® 9.0 and above
Course Objectives:

Upon successful completion of this course, students will be able to:

  • Create automatic and manual running totals
  • Work with cross-tab reports
  • Add subreports
  • Create drill-downs in a report
  • Use SQL statements in report processing
  • Create complex formulas
  • Add charts to reports
  • Enhance report functionality
Course Outline:
  • Creating Running Totals
    • Create a Running Total Field
    • Modify a Running Total Field
    • Create a Manual Running Total

 

  • Working with Cross-Tabs
    • Create a Cross-Tab Report
    • Format a Cross-Tab Report
    • Create Groups in Cross-Tab Reports

 

  • Adding Subreports
    • Insert a Subreport
    • Edit a Subreport
    • Share Variables

 

  • Creating Drill-Downs in a Report
    • Create a Drill-Down
    • Create Headings for Drill-Down Data

 

  • Using SQL Statements in Report Processing
    • Create a Report Using SQL Queries
    • Summarize Report Data
    • Create Joins Using SQL
    • Create Subqueries
    • Create a SQL Expression Field

 

  • Creating Complex Formulas
    • Work with Loops
    • Work with Arrays
  • Adding Charts to Reports
    • Create Charts
    • Create a Chart with a Drill-Down
    • Create a Top N Chart
    • Create a Cross-Tab Chart
    • Create Charts for Grouped Data
    • Format a Chart
    • Create a Chart Template

 

  • Enhancing Report Functionality
    • Organize Data Based on a Hierarchy
    • Create a Dynamic Image
    • Create a Report Alert
    • Create a Geographic Map

 

  • Managing Reports
  • Processing Data on the Server
  • Detecting and Fixing Problems