4.60 (660 reviews)
$1,210
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
Classroom sessions are delivered at a nominated location (Private courses only). Inclusions: |
Full Day Sessions: Half Day Sessions: |
|
Live online sessions are virtual instructor-led sessions conducted online from your location. You will be sent an invitation to join the session. There is no need for software just a computer with an internet connection and a browser. |
Full Day Sessions: Half Day Sessions Times: |
Available Crystal Reports Essentials courses
Event | Event Date | Location | Individual Price | Register |
---|---|---|---|---|
Crystal Reports Essentials: May 16-17 | 16-05-2024 | Live Online | $1,210.00 | |
Crystal Reports Essentials: Aug 15-16 | 15-08-2024 | Live Online | $1,210.00 | |
Crystal Reports Essentials: Nov 28-29 | 28-11-2024 | Live Online | $1,210.00 |
Brochure