Back to Search Results

Training Course Summary:

Course Overview

This one-day course is designed to further increase report design skills by concentrating on advanced topics. The course covers Crystal architecture, report design and Structured Query Language, advanced formula creation such as arrays and custom functions, sub-reports, and a hands-on report design workshop. In the Report Design Workshop, you will build upon topics you’ve learned throughout the Report Design courses. Each activity in the workshop presents a different business scenario in which to apply your report design skills. The reports you develop in this workshop can also be used as a guide for your own reporting needs.

Who Should Attend

Learners who want to further develop their basic report design skills using Crystal Reports 9.

What You Will Learn

At the end of this course the course participant will understand the architecture of Crystal Reports, be able to apply database options, broaden their knowledge of formulas and create sub-reports. In addition course participants will be given the opportunity to confirm their knowledge of Crystal Reports by means of a workshop.



Pre-requisites



Learners must have taken Report Design I and II courses or have a minimum of six months of report design experience with Crystal Reports and understand advanced report design concepts such as formulas, parameters, sections, cross-tabs, and exporting. Relational database knowledge is recommended. Learners who have not completed Report Design I and II courses should complete the prerequisite exercise, which is available from the Crystal Decisions website, and bring it to the course.



Follow-up Courses

None



Course Content

Architecture

Understanding the core components
Understanding multi-pass reporting
Understanding key dynamic link libraries

Working with Databases
Accessing data sources
using SQL to process reports
Applying database options
Adjusting to database changes

Formulas
Understanding formula sizing limitations
Using arrays
Using advanced control structures
Using custom functions

Subreports
Defining subreports
Creating an unlinked subreport
Creating a linked subreport
Adding catpions to subreports
Updating subreports
Using shared variables

Report Design Workshop
Understanding the Workshop objectives
Setting up your systems for the Workshop
Choosing your Workshop scenarios and activities
Building your Workshop reports