
Crystal Reports Level 1 (Basic)

Organizations use reporting tools to access data sources and generate customized reports. Crystal Reports enhances report building and report processing techniques with a variety of features that add value to a presentation. In this course, you will create a basic report by connecting to a database and modifying the report's presentation.
Information is critical to making sound business decisions. Data presented without any formatting or structure holds little or no meaning for interpretation. Crystal Reports helps you build advanced reports with ease, presenting complex information in an understandable way.

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

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.

Section 1: Exploring the Crystal Reports Interface
Explore Crystal Reports
Use Crystal Reports Help
Customize Report Settings
Section 2: Working with Reports
Create a Report
Modify a Report
Display Specific Report Data
Work with Report Sections
Section: 3: Using Formulas in Reports
Create a Formula
Edit a Formula
Filter Data by Using a Formula
Work with Advanced Formulas and Functions
Handle Null Values
Section 4: Building Parameterized Reports
Create a Parameter Field
Use a Range Parameter in a Report
Create a Prompt
Section 5: Grouping Report Data
Group Report Data
Modify a Group Report
Group by Using Parameters
Create a Parameterized Top N Report
Section 6: Enhancing a Report
Format a Report
Insert Objects in a Report
Suppress Report Sections
Use Report Templates
Section 7: Creating a Report from Excel Data
Create a Report Based on Excel Data
Modify a Report Generated from Excel Data
Update Data in a Report Based on Excel Data
Section 8: Distributing Data
Export Data
Create Mailing Labels
This Course Comes With
![]() PDF ManualTake the manual anywhere and save the environment with an electronic copy of your training manual for use on any of your computers or devices |
Also Available With This Course
![]() Printed ManualInstead of the PDF that comes with your course, purchase a printed paper manual for use during your class and future reference |
Customize Your Course
![]() Tailored TrainingYour manual will follow a standard course outline but your class can be tailored to focus on the subjects that are most important to you |
![]() Use Your Own FilesWhether it's one-on-one or group training you can give us files to include in your training session and help you apply what you learn even more! |

Level 1 (Basic)

Guaranteed to Run
Even with one participant,
our classes are guaranteed to run!
Even with one participant,
our classes are guaranteed to run!
Register for Online Classes
This course does not currently have any public classes scheduled. To inquire about the next class or arrange a private class please use the form below.
Online registration closes two business days before the start of the class.
Questions?
Do you have questions about this course? Would you like a class sooner or on a
different date? Are you interested in scheduling a private group class?
Please submit the simple form below and we will respond promptly.

Private Training for GroupsIf you are training 4+ people, a private training session may be more cost-effective. Click to contact us today and learn more.

Newsletter Signup