Course Syllabus: Crystal Reports

Crystal Reports is a user-friendly report creation tool created and distributed by SAP.  The program is run on the Windows operating system.  It allows users to easily create and design detailed reports using data from various data sources, such as Excel spreadsheets, Oracle databases, Microsoft Access databases, MySQL server databases, and even local files.   The data that Crystal Reports gathers can be used in a multitude of report types, including list reports, mailing label reports, customer letters, financial analysis, activity, summaries, and much more.

This course was created for anyone who wants to learn Crystal Reports.  It doesn't matter if you already have experience with Crystal Reports or are a complete newbie to the software.   We will teach you the program from beginning to end so that anyone, regardless of experience, learns all that they need to know to successfully use the program. 

You will learn how to:

·    Connect to data sources such as Access and MySQL databases and Excel spreadsheets.

·    Add tables and views from data sources to be used in Crystal Reports

·    Create a report

·    Add data fields to a report

·    Format, align, and move data fields and headers to begin to customize a report

·    Add special data fields to a report

·    Add non-data objects to a report

·    Sort and filter data in a report

·    Organize data into groups

·    Add grand total and sub-total fields

·    Create and work with parameter fields

·    Create and use formula fields

·    Insert charts into a report

·    Link multiple tables together

·    Export and distribute reports

·    And more

This course will not require you to have previous experience in any particular area but you should have the following:

-Crystal Reports 2013 (recommended) *
- a high school reading level.


No books will be required.

*students interested can download the free trial version of the current version of  Crystal Reports for this course. 

You will learn how to:

·        Connect to data sources such as Access and MySQL databases and Excel spreadsheets.

·        Add tables and views from data sources to be used in Crystal Reports

·        Create a report

·        Add data fields to a report

·        Format, align, and move data fields and headers to begin to customize a report

·        Add special data fields to a report

·        Add non-data objects to a report

·        Sort and filter data in a report

·        Organize data into groups

·        Add grand total and sub-total fields

·        Create and work with parameter fields

·        Create and use formula fields

·        Insert charts into a report

·        Link multiple tables together

·        Export and distribute reports

·        And more

All course material will be provided in the lessons and netlinks. There are no required materials to purchase before taking the class. In order to fully benefit from this course, though, you do need access to Crystal Reports.

Each lesson will include a lesson review exam along with an assignment. Students will successfully complete this course with 70% or better.

By successfully completing this course, students will be able to: