Crystal Reports Essentials Training

• Use a mouse
• Type and use a keyboard
• Navigate through Windows, organise folders and files
• Work with Windows - Minimise, Maximise, Open, Close
• A basic understanding of database principles, including: relationships between tables; joins and primary keys; experience of using data manipulation software, such as Microsoft Access or Microsoft Excel
• Prior knowledge of SQL is desirable, but not essential

• Explore the Crystal Reports interface
• Create a basic report and modify it
• Use formulas to calculate and filter data
• Build a parameterised report
• Group report data
• Enhance a report
• Create a report using data sourced from an Excel database
• Distribute data

Lesson 1: Exploring the SAP Crystal Reports Interface

• Topic 1A: Explore Crystal Reports
• Topic 1B: Use Crystal Reports Help
• Topic 1C: Customise the Report Settings

Lesson 2: Working with Reports

• Topic 2A: Create a Report
• Topic 2B: Modify a Report
• Topic 2C: Display Specific Report Data
• Topic 2D: Work with Report Sections

Lesson 3: Using Formulas in Reports

• Topic 3A: Create a Formula
• Topic 3B: Edit a Formula
• Topic 3C: Filter Data Using a Formula
• Topic 3D: Work with Advanced Formulas and Functions
• Topic 3E: Handle Null Values

Lesson 4: Building Parameterised Reports

• Topic 4A: Create a Parameter Field
• Topic 4B: Use a Range Parameter in a Report
• Topic 4C: Create a Prompt

Lesson 5: Grouping Report Data

• Topic 5A: Group Report Data
• Topic 5B: Modify a Group Report
• Topic 5C: Group by Using Parameters
• Topic 5D: Create a Parameterised Top N Report

Lesson 6: Enhancing a Report

• Topic 6A: Format a Report
• Topic 6B: Insert Objects in a Report
• Topic 6C: Suppress Report Sections
• Topic 6D: Use Report Templates

Lesson 7: Creating a Report from Excel Data

• Topic 7A: Create a Report Based on Excel Data
• Topic 7B: Modify a Report Generated from Excel Data
• Topic 7C: Update Data in a Report Based on Excel Data

Lesson 8: Distributing Data

• Topic 8A: Export Data
• Topic 8B: Create Mailing Labels