Comprehensive Crystal Reports 2011 Training

This 4 day Crystal Reports class is intended for those who have little to no experience with Crystal Reports.  The course will provide students with a general overview of the basic functionality and a general understanding of report design, including the need to provide quality reports in various presentation formats.  The latter half of the course will focus on database functionality and the more advanced features of Crystal Reports Students will gain practical experience through hands-on exercises.

Please note that XI is the older version of Crystal Reports and should not be confused with 2011.

Goals

  • Gain familiarity with the Crystal Reports interface.
  • Learn to create and modify reports.
  • Learn to format reports.
  • Learn to filter reports.
  • Learn how to sort and group report fields.
  • Learn how to use multiple tables within a report.
  • Learn how to create formulas.
  • Learn to create summary reports.
  • Learn how to export and distribute reports.
  • Learn about databases and SQL.
  • Learn about custom functions.
  • Learn about more advanced functions.
  • Learn how to make reports more efficient and effective.
  • Learn about charts.
  • Learn about report alerts.

Outline

  1. Getting Acquainted with Crystal Reports
    1. Creating Our First Report
    2. The Database Expert
    3. Review the Toolbars
    4. The Report Sections in the Design Tab
    5. The Field Explorer
    6. Preview the Report
    7. Adding Multiple Tables to Reports
  2. Formatting Reports
    1. Formatting Fields
    2. The Format Painter
  3. Working with Objects
    1. Text Objects
    2. Field Titles
    3. Using Fields in Text Objects
    4. Aligning and Sizing Objects
    5. The Section Expert
    6. Images
  4. Filtering Reports
    1. Create a Filter Based on a Single Criteria
    2. Create a Filter for Multiple Selection Criteria
  5. Sorting and Grouping Reports
    1. Using the Sort Expert
    2. Using the Group Expert
    3. Summarizing Records within Groups
  6. Using Basic Formulas
    1. String Formulas
    2. Numeric Formulas
    3. Date/Time Formulas
    4. Running Totals
    5. Conditional Formulas
  7. Advanced Formatting
    1. Using Multiple Sections
    2. Summary Reports
    3. Lines and Boxes
    4. The Highlighting Expert
  8. Exporting and Distribution
    1. Exporting to Excel
    2. Exporting to PDF
    3. Exporting to Word
    4. Crystal Reports Viewer
    5. crystalreports.com
  9. Crystal Reports Refresher
    1. Creating a Crystal Report
  10. Using Parameters
    1. Creating Parameters
    2. Optional Parameters
    3. Using a List of Values
    4. Using Parameters
  11. Subreports
    1. Unlinked Subreports
    2. Linked Subreports
  12. Charts
    1. Adding Charts to Reports
  13. Cross-tabulation Reports
    1. Using Cross-tabulation Reports
  14. Working with SQL
    1. The SELECT Statement
    2. The WHERE Clause
    3. The ORDER BY Clause
    4. Joins
    5. SQL Commands
    6. SQL Expressions
  15. Advanced Techniques
    1. Special Fields
    2. Using the Select Case Statement
    3. Evaluation Time Functions
    4. Conditional Formatting
    5. Alternating Row Formatting
  16. Report Alerts
    1. Using Report Alerts

To Hire an AMS Crystal Reports Subject Matter Expert and Instructor who also teaches this class, call us today at 800-798-3901!

Leave a Reply