	What's New Contact Us Home
	Trusted Data, Confident Solutions

About Us Training Seminars Consulting Solutions Subscribe Testimonials

Home > Training > Training for Designers > Crystal Reports 2008: Optimizing Report Data

Training
	Training for Designers

	Training for Data Managers

	Training for System Administrators

Crystal Reports 2008: Optimizing Report Data

Course ID Number: BOC345
Date: 01/01/2010 - 12/30/2011
Location: Your Desktop
Time: 8 hours
Software Version: CR2008
Price: $695
Promotions: Enhance your e-learning experience with our special offer

Directions

Course Description

This eight hour eLearning course will instruct on how to set up, configure, and maintain data connections for reports.
You will learn how to link data, optimize reports, and push processing to the database server.
As an established report designer within your company, you will gain a more advanced understanding of data connectivity within the Crystal Reports 2008 environment.

Course Audience
The target audience for this course is report designers with strong report-design skills. This course will teach you to optimize reports for faster and more efficient data processing.

Course Topics

Exploring the Database Expert

Accessing the database expert
Adding and removing data sources
Using options in the database expert
Using the data tab
Using the links tab

Identifying the Effects of Link Types

Defining links and jobs
Using inner joins, left outer joins, right outer joins, and full outer joins
Identifying syntax diffrences between databases
Joining different data types

Setting Up and Configuring Data Sources

Using native connections

Using ODBC connections

Using OLE connections

Configuring ODBC

Setting up data sources to Microsoft Access and Microsoft SQL Server

Updating Reports for Database Changes

Setting the data source location
Mapping database fields
Verifying the database

Processing Data on the Server

Optimizing record selection
Using SQL expressions
Performing grouping on a server

Validating the Report Data

Handling NULL values in reports
Handling NULL values in formulas and record selection
Confirming the report data

Detecting and Fixing Problems

Finding resources to fix issues
Using utilities to diagnose issues
Getting additional help to resolve issues

Prerequisite Education

Designers who attend this course should have completed the following:

Crystal Reports XI R1/R2: Report Design I
Crystal Reports XI R1/R2: Report Design II
Crystal Reports XI R1/R2: Report Design III

Prerequisite Knowledge/Experience

In this course, you will be working intensively with Crystal Reports. To successfully understand the content and complete the activities, you must have:

Knowledge of basic database concepts
Knowledge of basic SQL concepts

Delivery & Duration
8 hours

Applicable Certification
This course is a course in the Business Objects Certified Professional program: Crystal Reports 2008.

Directions


	Home \| What's New \| Contact Us \| About Us \| Training \| Seminars \| Consulting \| Solutions \| Subscribe \| Testimonials \| Privacy Policy

Site Development Tara Communications LLC