651-905-3729 Microsoft Silver Learning Partner EC Counsel Reseller compTIA Authorized Partner

Crystal Reports - Introduction Virtual Classroom Live January 21, 2025

Price: $895

This course runs for a duration of 2 days.

The class will run daily from 9 AM CT to 3:45 PM CT.

Class Location: Virtual LIVE Instructor Led - Virtual Live Classroom.

Enroll today to reserve your spot!

Space is limited. Enroll today.

Enroll Now

Description

Overview

In this course, students will create a basic report by connecting to a database and modifying the report's presentation.

Objectives

In this course, you will connect to a database to extract data and present it as a report. You will: 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.

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.

 

Course Overview

Lesson 1: Exploring the Crystal Reports Interface

  • Topic A: Explore Crystal Reports
  • Topic B: Use Crystal Reports Help
  • Topic C: Customize Report Settings

Lesson 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

Lesson 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

Lesson 4: Building Parameterized Reports

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

Lesson 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

Lesson 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

Lesson 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

Lesson 8: Distributing Data

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

Appendix A: Setting Up and Configuring Data Sources
Appendix B: Using Report Processing Techniques
Appendix C: Using Functions in Formulas

Other Available Dates for this Course

Virtual Classroom Live
January 16, 2025

$895.00
  Featured Class 2 days    8 AM CT - 4 PM ET
view class details and enroll
Virtual Classroom Live
March 10, 2025

$895.00
  Featured Class 2 days    8 AM CT - 4 PM ET
view class details and enroll
Virtual Classroom Live
March 17, 2025

$895.00
2 days    9 AM CT - 3:45 PM CT
view class details and enroll
Virtual Classroom Live
May 15, 2025

$895.00
  Featured Class 2 days    8 AM CT - 4 PM ET
view class details and enroll