Course Description
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 is 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
- Completely Online
- Self-Paced
- Printable Lessons
- Full HD Video
- 6 Months to Complete
- 24/7 Availability
- Start Anytime
- PC & Mac Compatible
- Android & iOS Friendly
- Accredited CEUs

Learning Outcomes
- Describe what Crystal Reports is and what it can do for you.
- Summarize formatting techniques in Crystal Reports.
- Identify special data fields in Crystal Reports.
- Identify non-data object in Crystal Reports.
- Summarize sorting data techniques in Crystal Reports.
- Summarize filtering data techniques in Crystal Reports.
- Summarize grouping data techniques in Crystal Reports.
- Summarize adding data summary fields in Crystal Reports.
- Summarize working with parameter fields.
- Summarize working with formulas, charts, and the report card wizard.
- Summarize exporting and distributing reports.
- Demonstrate mastery of lesson content at levels of 70% or higher.
Assessment Guide
Assessment | Points |
---|---|
Course Introduction and Goals | 1 points |
Exam 1 | 10 points |
Exam 2 | 10 points |
Exam 3 | 9 points |
Exam 4 | 10 points |
Exam 5 | 10 points |
Exam 6 | 10 points |
Exam 7 | 10 points |
Exam 8 | 10 points |
Exam 9 | 10 points |
Exam 10 | 10 points |
Exam 11 | 10 points |
Exam 12 | 10 points |
Exam 13 | 10 points |
Exam 14 | 10 points |
Exam 15 | 10 points |
Exam 16 | 10 points |
Exam 17 | 10 points |
Exam 18 | 10 points |
Final Exam | 89 points |