In this hands-on Crystal Reports course, you will learn to create sophisticated reports from the ground up and transform raw data into meaningful information. You will gain the knowledge and skills to link multiple data sources and create effective presentations using Crystal Reports. After this training course, you will return to your organisation with a detailed process to help you retrieve and format data, create meaningful reports for widespread distribution, and integrate your reports with a website or application, such as .NET.
Save More on Training with Learning Tree Training Vouchers!
Our flexible, easy-to-redeem training vouchers are available to any employee within your organisation. For details, please call 0800 282 353 or chat live.
In Class & Live, Online Training
Note: This course runs for
AFTERNOON START: Attend these live courses online via Anyware
30 Sep - 1 Oct
2:00 PM - 9:30 PM BST
Herndon, VA / Online (AnyWare)
Herndon, VA / Online (AnyWare)
Reserve Your Seat
Guaranteed to Run
When you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time — will run. Guaranteed.
Crystal Reports Course Information
Should be comfortable using Windows and working with a spreadsheet or word processor
Experience working with formulas in a spreadsheet program
Which software is being used?
This course cover the latest version of Crystal Reports 2016 and backwards compatible to 2008. Any new changes or additions in later versions will be identified so students will know exactly what is included in their Crystal Reports version.
Crystal Reports Course Outline
Overview of Crystal Reports
Formatting and summarising data
Filtering, sorting and grouping data
Customising reports with business logic
Connecting to SQL Server, Oracle and Access databases
The Crystal Report Writer
Writing a basic report
Selecting a format
Adding text and fields
Connecting to remote data sources
Configuring the reporting environment
Formatting and styling
Tailoring sections within a report
Designing fields for quality presentations
Highlighting data with Highlight Expert
Linking Crystal Reports to Data
Connecting to popular data sources
Reporting from stored procedures and views
Establishing data connections
Creating a connectivity checklist
Configuring ODBC and OLE DB
Integrating SQL commands in a report
Interpreting Structures and Retrieving Data
Navigating complex data
Deciphering data structures
Identifying data relationships
Gathering the right data
Merging data from multiple tables
Building business queries
Combining Powerful Report Techniques
Organising and summarising reports
Sorting user sort control and grouping
Summary and Rolling Total fields
Building advanced reports
Embedding linked and unlinked subreports into reports
Creating crosstab and drill-down reports
Designing dynamic and cascading prompts
Hyperlinking Reports and Multilingual Reports
Achieving reusability with templates
Visualising complex data
Simplifying data with charts and graphs
Organising fields into sections
Adding, merging, suppressing sections
Programming Data Functionality
Coding in formula language
Working with variables and operators
Deciphering formula syntax
Adding and modifying formulas
Calling and working with functions
Writing effective formulas
Building if/then/else statements
Converting and comparing data
Debugging the code
Employing the Formula Workshop
Converting to Basic Syntax
Writing formulas with Basic Syntax
Laying a foundation for complex reporting logic
Crystal Reports Training FAQs
Can I learn to Crystal Reports online?
Yes! We know your busy work schedule may prevent you from getting to one of our classrooms which is why we offer convenient online training to meet your needs wherever you want. This course is available in class and live online.
What version of Crystal Reports is this course applicable for?
This course cover the latest version of Crystal Reports 2016 and backwards compatible to 2008.