Crystal Reports Level 3
Working World provides training on many of the leading software programs and applications. To book your next computer training course please call our main office number at (800) 463-3074.
Objectives
In these two days, time will be spent walking through the tips and tricks of advanced report writing along with a good amount of hands on practice. In addition, you will cover custom function, advanced formulas and report efficiencies techniques. This course incorporates a number of hands on exercises that reinforce the learning process.
Course Length
- 2 days
Content
Advanced Database Topics and Formulas
Refresher Exercise
- Review of Planning a Report
- Creating the Report
- Placing Fields on the Report
- Advanced Grouping
- Selecting Certain Records
- Group Sorting
- Group Charting
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
Using the Advanced Formula Features
- Advanced Formula Syntax
- Review If…Else…Then Expressions
- Select Case
- Immediate IF (IIF)
- For Loops
- Exit For
- Join Function
- Split Function
- Array Sizing Limitations
Crystal Reports, Data Access and SQL
- What is SQL
- Direct Database Drivers
- ODBC
- OLE DB
- Viewing the SQL
- SQL Commands
- Creating an SQL Command
- Adding Parameters to the SQL Command
- SQL Expressions
- Creating an SQL Command
Advanced Database Concepts
- Using the Database Expert for Linking
- Order Links Dialog
- Index Legend Dialog
- Link Options Dialog
- Adding and removing Databases/Tables
- Adding a table Multiple Times
- Changing Join Types
- Database Changes
- Database Verification
- Set Data Source Location
- Re-maping Database Fields
- Views
- Stored Procedures
- Non-ODBC Connection Types
Tips, Tricks and Special Features
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
Manual Cross-Tab Reports
- What is a Manual Cross-Tab
- Creating a Cross-Tab Object
- Creating a Cross-Tab without the Expert
Tips and Tricks
- Formatting Subreports
- Parameter Tricks
- Conditional Formatting
- Formatting page Headers
- Using Unique Fonts in the Report
- String Fields and Dates
- Dates Activity
OLAP Reporting
- OLAP Explanation
- OLAP Servers
- Creating an OLAP Report
- Formatting an OLAP Report
"It is a huge comfort level, I can't imagine going back, dealing with our previous IT company, you guys are great, your staff are all professional, very friendly and that's not said lightly. It's like having our own IT person right in the building. All I have to do is pick up the phone and your either helping us right away, or logging in. Your repairs and everything you do for us is very timely. I won't hesitate recommending you guys for a minute."- Cathy Taylor, Double D Transport
