Skip to Scheduled Dates
Course Overview
In this course, students will create a basic report by connecting to a database and modifying the report's presentation.
Who Should Attend
This course is designed for people who need output from a database. In some cases, database programs have limited reporting tools, or tools that are not accessible. Learners may or may not have programming or SQL experience.
Course Objectives
- Identify the elements of the Crystal Reports interface.
- Create and modify a basic report.
- Use formulas to calculate and filter data.
- Build a parameterized report.
- Group report data.
- Enhance a report.
- Create a report using data from an Excel workbook.
- Distribute data.
Course Outline
1 - EXPLORING THE CRYSTAL REPORTS INTERFACE
- Topic A: Explore Crystal Reports
- Topic B: Use Crystal Reports Help
- Topic C: Customize Report Settings
2 - WORKING WITH REPORTS
- Topic A: Create a Report
- Topic B: Modify a Report
- Topic C: Display Specific Report Data
- Topic D: Work with Report Sections
3 - USING FORMULAS IN REPORTS
- Topic A: Create a Formula
- Topic B: Edit a Formula
- Topic C: Filter Data by Using a Formula
- Topic D: Work with Advanced Formulas and Functions
- Topic E: Handle Null Values
4 - BUILDING PARAMETERIZED REPORTS
- Topic A: Create a Parameter Field
- Topic B: Use a Range Parameter in a Report
- Topic C: Create a Prompt
5 - GROUPING REPORT DATA
- Topic A: Group Report Data
- Topic B: Modify a Group Report
- Topic C: Group by Using Parameters
- Topic D: Create a Parameterized Top N Report
6 - ENHANCING A REPORT
- Topic A: Format a Report
- Topic B: Insert Objects in a Report
- Topic C: Suppress Report Sections
- Topic D: Use Report Templates
7 - CREATING A REPORT FROM EXCEL DATA
- Topic A: Create a Report Based on Excel Data
- Topic B: Modify a Report Generated from Excel Data
- Topic C: Update Data in a Report Based on Excel Data
8 - DISTRIBUTING DATA
- Topic A: Export Data
- Topic B: Create Mailing Labels
9 - APPENDIX
- Appendix A: Setting Up and Configuring Data Sources
- Appendix B: Using Report Processing Techniques
- Appendix C: Using Functions in Formulas