Preferred method of contact:

Crystal Reports

COURSE TYPE

Intermediate

Course Number

126

Duration

4 Days

PDF Add to WishList

Gain the knowledge and skills to link multiple data sources and create effective presentations using Crystal Reports. With 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.

You Will Learn How To

  • Develop reports to transform data into meaningful information
  • Create advanced graphical and crosstab reports
  • Add calculations and program logic with the Formula Workshop
  • Connect to data sources and extract data to meet reporting needs
  • Deploy reports via HTML, Visual Basic, and .NET

Important Course Information

Recommended Experience:

  • Should be comfortable using Windows and working with a spreadsheet or word processor
  • Experience working with formulas in a spreadsheet program

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

  • SQL Server
  • Oracle
  • Access
  • Web logs
  • XML
  • 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
  • Deploying Reports to the Internet, Visual Basic and .NET

Deploying Crystal Reports

  • Deciding amongst Push, Pull, Static and Dynamic reports
  • Migrating to production by switching databases

Publishing reports to a website and integrating into custom applications

  • Exploring development options
  • Exporting reports to PDF, Excel, Word and HTML
  • Adding Crystal Reports to a .NET application
Show complete outline
Show Less

Convenient Ways to Attend This Instructor-Led Course

Hassle-Free Enrolment: No advance payment required to reserve your seat.
Tuition Fee due 30 days after you attend your course.

In the Classroom

Live, Online

Private Team Training

In the Classroom — OR — Live, Online

Tuition Fee — Standard: £1345  

AFTERNOON START: Attend these live courses online via Anyware

19 - 22 Dec (4 Days)
2:00 PM - 9:30 PM GMT
New York / Online (AnyWare) New York / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

18 - 19 Jun (2 Days)
2:00 PM - 9:30 PM BST
New York / Online (AnyWare) New York / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

13 - 14 Nov (2 Days)
2:00 PM - 9:30 PM GMT
New York / Online (AnyWare) New York / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

Guaranteed to Run

Private Team Training

Enroling at least 3 people in this course? Consider bringing this (or any course that can be custom designed) to your preferred location as a private team training.

For details, call 0800 282 353 or Click here »

Tuition Fee

Standard

In Classroom or
Online

Standard

£1345

Private Team Training

Contact Us »

Course Tuition Fee Includes:

After-Course Instructor Coaching
When you return to work, you are entitled to schedule a free coaching session with your instructor for help and guidance as you apply your new skills.

Free Course Exam
You can take your Learning Tree course exam on the last day of your course or online at any time after class and receive a Certificate of Achievement with the designation "Awarded with Distinction."

Prev
Next

Training Hours

Standard class hours:
9:00 a.m. - 4:30 p.m.

Last day class hours:
9:00 a.m. - 3:30 p.m.

Free Course Exam – Last Day:
3:30 p.m. - 4:30 p.m.

Each class day:
Informal discussion with instructor about your projects or areas of special interest:
4:30 p.m. - 5:30 p.m.

AFTERNOON START class hours:
2:00 p.m. - 9:30 p.m.


Last day class hours:
2:00 p.m. - 8:30 p.m.


Free Course Exam – Last Day:
8:30 p.m. - 9:30 p.m.


Each class day:
Informal discussion with instructor about your projects or areas of special interest
9:30 p.m. - 10:30 p.m.

“Taking the Crystal Reports course was valuable to me because it gave me a chance to understand the parent/child link table relationships, which is critical in my current position”.

- S. Dickens, Software Engineer
Praxis Engineering Technology

Prev
Next
Chat Now

Please Choose a Language

Canada - English

Canada - Français