4.60 (660 reviews)
$1,295
Real-time access to essential data
with rapid generation of multidimensional reports
Crystal Reports is the in-demand business intelligence software used to design and generate reports. Crystal Reports works with a range of data sources, including Microsoft Excel spreadsheets, Oracle databases, Microsoft SQL Server, Microsoft Access databases, Business Objects Enterprise, and local file system information. In this course you will:
Connect to different databases to extract data and present it as a report.
Learn to use the the elements of the Crystal Reports interface.
Create and modify a basic reports and enhance using formatting options.
Use formulas to calculate and filter data.
Build a parameterized report.
Group report data.
Create a report using data from an Excel workbook.
Distribute reports.
Course Overview
This course is suitable for users of the following versions of Crystal Reports: v11, 2008, 2011, 2013 and 2016.
Audience:
This course would suit people who are new to Crystal Reports and who are/will be responsible for creating and distributing reports.
Prerequisites:
Participants must have a proficient knowledge of Microsoft Windows. Basic knowledge of database concepts is recommended.
Course Content
Introduction to Crystal Reports
- Getting started
- Exploring the report design environment
- Creating and saving reports
- Placing objects on your report
- Modifying reports
- Formatting objects
- Positioning and sizing objects
- The Help feature
Creating Reports
- Using the Wizard
- Linking a Data source
- Linking to a source with multiple tables
- Adding Fields to a report
Organising Records
- Sorting
- Record selection
- Using Select Record options
- Understanding saved -v- refreshed data
- Setting selection criteria
Working with Report Sections
- Creating a Section
- Resizing a Report section
- Merging report sections
- Managing section order
Groups and Summaries
- Grouping records
- Modifying groups
- Grouping on date fields
- Summaries
- Grand Totals
Formulas and Functions
- Formulas
- Working with the formula editor
- Performing basic calculations
- Modifying formulas
- Using Functions
Experts and wizards
- Database Expert
- Report wizards
Formatting for Presentation Quality Reports
- Formatting text objects
- Inserting lines, boxes and pictures
- Conditional formatting
- Section formatting
Distributing Reports
- Exporting reports
- Delivering reports
Delivery Options
Public Courses
Live online - learn by doing.
Our Live Online courses are conducted through a dedicated learning platform that enables us to provide instructor-led, hands-on training to develop real skills, in real time. Each participant logs into their own virtual environment setup specifically for the course. This is a fully interactive experience - just like in a classroom. No passive lectures. No videos to follow - real time hands-on practice with your instructor guiding you every step.
Instructor:
- provides real-time live hands-on instruction and demonstration,
- provides step-by-step practical activities for participants,
- can assist participants on their screen, if necessary,
- can share participant screens to enhance discussion.
Participants:
- receive hands-on instruction, step-by-step exercises and skill-builder activities,
- see the instructor screen while working on their own environment,
- can interact with the instructor and the group of participants,
- can ask questions at any time,
- join the course from any location with internet using a Course Invitation.
- no need for any software, just a computer with internet and a browser.
- no downloads on installs necessary on the participant computer.
Inclusions:
- E-Book Training Manual/activity booklet will be provided
- Certificate of Completion
- Post-course support to the level of the course
- Access to any training exercises used during the session
Session Times:
- Full Day Course: 9:00 am-4:30 pm
- Half Day Course: 9:00 am-12:30 pm or 1:30 pm-5:00 pm
Private Courses
Private sessions can be arranged through our Live Online platform for group training. Group training content and duration can also be tailored to your needs. To discuss your training requirements, contact our Course Scheduling team.
Classroom
Classroom sessions are delivered at a nominated location (Private courses only).
Requirements:
If training is being delivered on your site:
- A computer is required for each participant, configured with appropriate software (if necessary).
- If participants are using laptops, ensure power cords are provided for use during the session.
- The instructor will bring their own laptop - please provide power
- Screen/Projector for trainer to connect their laptop to. Please indicate the connection method - hdmi or wifi.
Inclusions:
- Training Manual/activity booklet
- Certificate of Completion
- Post-course support for queries relating to the course content.
This is a 2 day course. Course days run consecutively from the Event Date below.
Available Crystal Reports Essentials courses
| Event | Event Date | Location | Individual Price | Register |
|---|---|---|---|---|
| Crystal Reports Essentials | 02-04-2026 | Live Online | $1,295.00 | |
| Crystal Reports Essentials | 19-05-2026 | Live Online | $1,295.00 | |
| Crystal Reports Essentials | 06-07-2026 | Live Online | $1,295.00 |
Brochure