CRYSTAL REPORTS 2008 DESIGNER 3 WORKSHOP
Crystal Reports Training 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.
Crystal Reports Training Prerequisites
Successful completion of the Designer 1 and Designer 2 Workshops is strongly recommended.
Crystal Reports Training Audience
Administrators, developers and end-users who need to create dynamic reports from varying data sources.
Crystal Reports Training Course duration
2 days
Crystal Reports Training Course outline
Refresher Exercise
Review of Planning a Report
Creating the Report
Placing Fields on the Report
Advanced Grouping
Selecting Certain Records
Group Sorting
The Report Header
The Group Chart
Advanced Database Concepts
What is SQL?
Native Database Driver
ODBC
OLE DB
ODBC, OLE DB or Native
Using the Database Expert for Linking
Order Links Dialog
Index Legend Dialog
Link Options
Adding Tables to a Report Multiple Times
Changing the Join Type for a Link
Database Changes
Database Verification
Set Datasource Location
Re-mapping Database Fields
Views
Stored Procedures
SQL Commands
Creating a SQL Command
Adding a Parameter to the Command
Using Advanced Formula Features
Alternatives to the IF THEN ELSE Control Structure
Select Case Statement
Using the For Loop Control Structure
The Different Types of While Loops
While … Do
Do … While
Building Arrays
The Split Function
Crystal Formula Sizing Limitations
Custom Functions
Custom Function Arguments
When to Use a Custom Function
Creating Custom Functions
Creating a Custom Function Using the Custom Function Editor
Custom Function Properties
Using the Formula Expert and Custom Functions
Using the Formula Extractor
Custom Function Limitations
Running Reports Efficiently
Understanding What Crystal Can Pass to the Database
Strategies for Efficient Report Performance
Interpreting the SQL Query
Using a SQL Expression to Make a Report More Efficient
Record Selection and Performance
External Joins
Performance Information
Report Definitions
Saved Data
Processing
Latest Report Changes
Performance Timing
Server Based Grouping
Requirement s for Server Based Grouping
Select Distinct Command
Advanced Cross-Tab Design
Introduction to 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
Cross-Tab Calculated Members Expert
Tips and Tricks
Creating a Cross-Tab With the Expert
Formatting Subreports
Parameter Tips and Tricks
Conditional Formatting
Using Fonts to Enhance Readability of Your Report
Windows Character Map
Appendix A: Setup Instructions for Crystal Reports 2008
Crystal Reports 2008 Application Installation Instructions
Installing Required Class Files
Appendix B: Setup Instructions for SQL Server 2005 Express Edition
Installing SQL Server 2005 Express Edition
SQL Server 2005 Expression Edition Installation Instructions
Installing the AdventureWorks Database
Attaching the AdventrureWorks Database
Appendix C: The AdventureWorks Database
