Refresher Exercise
Formula Review
Group Review
Advanced Formatting Review
Subreport review
Custom Functions
Creating a custom function
Using the custom function editor
The formula expert
Using the formula extractor
Limitations of custom functions
Challenge Exercise – creating and using a custom function
Advanced Formula Syntax
Review of evaluation times and variables
Select Case Statement
Immediate IF function
IIF statement
For Loops
Exit For
While Do Loops
Join function
Split function
Challenge Exercise using advanced syntax
Data Access and SQL
What is SQL?
ODBC and OLE DB
Viewing the SQL
Creating a SQL command
Parametrizing a SQL command
Creating a SQL Expression
Manual Cross tabs
When do you need to use a manual cross tab
Benefits of a manual cross tab
Creating a manual cross tab
Advanced Database Concepts
Using the dialogs in the Database expert
Adding a table to a report multiple times
Stored procedures and views
ADO and other non-ODBC connection types
OLAP Reporting
Connecting to OLAP Data
Using Dimensions
Using Measure
Exporting
Formatting Data
Running Reports Efficiently
Strategies for efficient report performance
Analyzing report performance
Server based Grouping
Using the Select Distinct command
Tips and Tricks
Use non documented tips and tricks in challenge exercises to solve some common reporting design issues
APPENDIX A – The Xtreme Sample Database
A relational diagram of tables existing in the Xtreme Sample Database 11 provided on the Crystal Reports Installation CD
APPENDIX B – Installation and System Requirements
A complete listing of operating system and hardware requirements
APPENDIX C – Function and Operator Locations
A complete listing of operating system and hardware requirements
APPENDIX D – Glossary