Crystal Reports 2016 Designer 3
CLASS DATE(s):
9/1/2020 - 9/2/2020

COURSE LENGTH: 2 Days

COURSE COST: $695.00

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

Printable version of this course
print
Register for this course
register

COURSE OVERVIEW

This two-day workshop is designed to expand your working knowledge of Crystal Reports and move you into creating more complex reports. Time will be spent walking you through the tips and tricks of advanced report writing along with a good amount of hands on practice. In addition, you will cover custom functions, advanced formulas and report efficiencies techniques. This course incorporates a number of hands on exercises that reinforce the learning process.

AUDIENCE AND PREREQUISITES

This course is designed for people who know how to create basic list and group reports and need to create reports that include advanced formulas, and reports that may be based on more complex SQL statements. Students attending this course may or may not have programming and/or SQL experience.

Successful completion of the Designer 1 and 2 Workshops is strongly recommended.

PREREQUISITE COURSES  

*Course Cost listed does not include the cost of the courseware. Course is subject to a minimum enrollment to run. Course may run as a Virtual Instructor led class if the minimum enrollment is not met. For more information, please contact: learn@vtec.org or call 207-775-0244.

COURSE TOPICS:


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

Module 2: 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

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

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

Module 5: 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

Module 6: Advanced Cross-Tab Design
Dissecting a Cross-Tab Grid
Cross-Tab Parts Listing
Row and Column Indexes
Summary Indexes
Grid Value Functions
Embedded Summaries
Conditionally Formatting Embedded Summaries
Calculated Members

Module 7: Tips and Tricks