This one-day course is designed to further increase report design skills by concentrating on advanced topics. Along with hands-on practice, the course covers architecture, report design and Structured Query Language, advanced formula creation such as arrays and control structures, subreports, and an XML overview as it relates to Crystal Reports.

Prerequisites

Learners must have taken Report Design I and II or Introductory and Advanced Crystal Reports 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 report distribution options. Relational database knowledge is recommended.

What you will learn

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 UFLs

Understanding arrays

Using control structures

Subreports

Defining subreports

Creating an unlinked subreport

Creating a linked subreport

Creating an On-demand subreport

Using shared variables

Crystal
Reports and XML

XML overview

XML in Crystal Reports

Exporting to XML format

Customizing XML report
definitions

XML output specifications

Who
should attend

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