Object and Data Labs
  Certificates   Free Newsletter   What's New   Contact
              Sitemap
Main Areas
Onsite Training
Courses
Class Schedule
Registration
Tuition Discounts
Technology Library
Our Instructors
Our Customers
Why Object & Data Labs?

Hot New Courses:
XML: A Comprehensive Introduction
Disaster Recovery Planning

How students rate us

Free Newsletter
Visit our technology library and sign up to receive the latest word in technology from industry specialist.

Certification Available
Visit our certification page to see how you can be on the fast track to certification in advanced technologies.
  Home > Courses > Course Descriptions Print Page
Course Description

Crystal Report Design III (9)

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, subreports, 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.

Prerequisites

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 and bring it to class. Download CR_9_rd3_prerequisite.pdf Report Design III Prerequisite Exercise (PDF - 136 KB).

What you will learn

Architecture
  • Understanding the core components
  • Understanding multi-pass reporting
  • Understanding key dynamic link libriaries

Working with Databases

  • Accessing data sources
  • Using SQL to process reports
  • Applying database options
  • Adjusting to database changes
  • Saving data indexes

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
  • Creating an on-demand subreport
  • Adding captions to subreports
  • Updating subreports
  • Using shared variables

Report Design Workshop

  • Understanding the workshop objectives
  • Setting up your system for the worlshop
  • Choosing your Workshop scenarios and activities
  • Building your Workshop reports

Who should attend

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

 

Class Schedule  Registration

 

  Home | Courses | Class Schedule | Registration | About Us | Contact Call us TOLL FREE at 1-888-230-9052
Copyright 2003-2013, Object & Data Labs All Object & Data Labs Courses are certified courses with UC Berkeley & UCSC extension 

Website by Howard Pugh Web Design
Website maintained by Ann T. Comey