In this course, students will create complex reports & data sources using the tools in Crystal Reports 2016. Students will not only create more complex reports including sub-reports and cross-tabs, but will also increase their speed and efficiency.
Who Should Attend
This course is designed for people who know how to create basic list and group reports and need to create reports that include subreports, cross-tabs, advanced formulas, and charts based on more than one data series. They may also need to build tools that make it easier for other people to create reports. They may or may not have programming and/or SQL experience.
Course Objectives
In this course, you will create complex reports using tools in Crystal Reports 2016. You will: 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.
Lesson 1: Creating Running Totals
Lesson 2: Working with Cross-Tabs
Lesson 3: Adding Subreports
Lesson 4: Creating Drill-Downs in a Report
Lesson 5: Using SQL Statements in Report Processing
Lesson 6: Creating Complex Formulas
Lesson 7: Adding Charts to Reports
Lesson 8: Enhancing Report Functionality
Appendix A: Managing Reports
Appendix B: Processing Data on the Server
Appendix C: Detecting and Fixing Problems
You will need to have taken the following course (or equivalent knowledge):
Crystal Reports - Introduction
To ensure your success, a knowledge of programming and/or SQL would also be helpful.