Description
In this course, students will create a basic report by connecting to a database and modifying the report's presentation.Objectives
Course Objectives
In this course, you will connect to a database to extract data and present it as a report. You will:Target audience
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.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
There are no prerequisites for this course.