Crystal Reports 2013 Designer 3 Workshop
CLASS DATE(s):
Request a Class

COURSE LENGTH: 2 Days

COURSE COST: $695.00

COURSE TIMES: 9:00am - 4:30pm

Printable version of this course
print

COURSE OVERVIEW

This 2-day course covers the more complex and powerful features of Crystal Reports.

AUDIENCE AND PREREQUISITES

Experienced administrators, developers and end-users who are experienced with Crystal Reports.

A comfort level of understanding in regards to relational databases.

PREREQUISITE COURSES  

*Course cost listed does not include the cost of courseware (required) or lunch (optional). Please contact us at learn@vtec.org or 207-775-0244 for additional pricing information, or if you have any questions. Course subject to minimum enrollment.

COURSE TOPICS:


Refresher Exercise
Review of Planning a Report
Creating the Report
Placing Fields on the Report
Advanced Grouping
Selecting Certain Records
Group Sorting
Group Charting

Advanced Database Concepts
What is SQL?
Native Database Driver
ODBC
OLE DB
ODBC, OLE DB or Native
Using the Database Expert for Linking
Adding a table Multiple Times
Changing Join Types
Database Changes
Database Verification
Set Data Source Location
Re-mapping Database Fields


Views
Stored Procedures
SQL Commands
Creating an SQL Command

Using the Advanced Formula Features
Select Case Statement
For Loop Control Structure
Do...While Loops
Building Arrays
The Split Function
Array Sizing Limitations

Custom Functions
What is a Custom Function
Function Arguments
When to use a Custom Function
When to use a Custom Function
Using Crystal Syntax
Using Basic Syntax
Custom Function Properties
Using the Formula Expert and Custom Functions
Using the Formula Extractor
Custom Function Limitations

Running Reports Efficiently
Understanding What Crystal Sends to the Database
Strategies for Efficient Report Performance
Using the SQL Statement
Record Selection and Performance
Performance Information
Report Definition
Saved Data
Processing
Latest Report Changes
Performance Timing
Server Based Grouping
Select Distinct Command