Crystal Reports On-Demand: Comprehensive (Part 1 & Part 2) - On-Demand Course

  The Crystal Reports Part 1 course is designed to teach students how to create a basic report in Crystal Reports by connecting to a database and modifying the report's presentation.

Crystal Reports is software that helps users build advanced reports with ease, presenting complex information in an understandable way.

Topics covered in the course include:

• 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.

Target Student: This course is ideal for students who want to 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. Students should also have basic experience using databases like Microsoft Access.

From Crystal Reports Part 1:

Section 1: Exploring the Crystal Reports Interface
Lesson A: Explore Crystal Reports
Lesson B: Using Crystal Reports Help
Lesson C: Customize Report Settings

Section 2: Working with Reports
Lesson A: Creating a Report
Lesson B: Modifying a Report
Lesson C: Display Specific Report Data
Lesson D: Work with Report Sections

Section 3: Using Formulas in Reports
Lesson A: Creating a Formula
Lesson B: Edit a Formula
Lesson C: Filter Data by Using a Formula
Lesson D: Work with Advanced Formulas and Functions
Lesson E: Handle Null Values

Section 4: Building Parameterized Reports
Lesson A: Creating a Parameter Field
Lesson B: Using a Range Parameter in a Report
Lesson C: Creating a Prompt

Section 5: Grouping Report Data
Lesson A: Grouping Report Data
Lesson B: Modifying a Grouping Report
Lesson C: Grouping by Using Parameters
Lesson D: Creating a Parameterized Top N Report

Section 6: Enhancing a Report
Lesson A: Formatting a Report
Lesson B: Insert Objects in a Report
Lesson C: Suppress Report Sections
Lesson D: Using Report Templates

Section 7: Creating a Report from Excel Data
Lesson A: Creating a Report Based on Excel Data
Lesson B: Modifying a Report Generated from Excel Data
Lesson C: Update Data in a Report Based on Excel Data

Section 8: Distributing Data
Lesson A: Export Data
Lesson B: Creating Mailing Labels

From Crystal Reports Part 2:

Section 1: Creating Running Totals
Lesson A: Creating a Running Total Field
Lesson B: Modifying a Running Total Field
Lesson C: Creating a Manual Running Total

Section 2: Working with Cross-Tabs
Lesson A: Creating a Cross-Tab Report
Lesson B: Formatting a Cross-Tab Report
Lesson C: Creating Groups in Cross-Tab Reports

Section 3: Adding Subreports
Lesson A: Insert a Subreport
Lesson B: Edit a Subreport
Lesson C: Share Variables

Section 4: Creating Drill-Downs in a Report
Lesson A: Creating a Drill-Down
Lesson B: Creating Headings for Drill-Down Data

Section 5: Using SQL Statements in Report Processing
Lesson A: Creating a Report Using SQL Queries
Lesson B: Summarize Report Data
Lesson C: Creating Joins Using SQL
Lesson D: Creating Subqueries
Lesson E: Creating an SQL Expression Field

Section 6: Creating Complex Formulas
Lesson A: Work with Loops
Lesson B: Work with Arrays

Section 7: Adding Charts to Reports
Lesson A: Creating Charts
Lesson B: Creating a Chart with Drill-Down
Lesson C: Creating a Top N Chart
Lesson D: Creating a Cross-Tab Chart
Lesson E: Creating Charts for Grouped Data
Lesson F: Formatting a Chart
Lesson G: Creating a Chart Template

Section 8: Enhancing Report Functionality
Lesson A: Organize Data Based on a Hierarchy
Lesson B: Creating a Dynamic Image
Lesson C: Creating a Report Alert
Lesson D: Creating a Geographic Map