Course Description | Course Outline |Data Warehousing | IT Training

1. 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

2. Custom Functions

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

3. Using Advanced Formula Features

• Advanced Formula Syntax
• Review of If…then…else… Expressions
• Alternatives to the IF THEN ELSE Function
• Select Case Statement
• Immediate If Function
• IIF (expression, truePart, falsePart)
• For Loops
• Exit For
• While Do Loops
• Join Function
• The Split Function
• Crystal Formula Sizing Limitations

4. Crystal Reports, Data Access and SQL

• What is SQL?
• Direct Database Driver
• ODBC
• OLE DB
• Viewing the SQL
• SQL Commands
• Creating a SQL Command
• Adding a Parameter to the Command
• SQL Expressions
• Creating a SQL Expression

5. Advanced Database Concepts

• Using the Database Expert for Linking
• Order Links Dialog
• Index Legend Dialog
• Link Options Dialog
• Adding and Removing Databases/Tables from the Report
• Adding Tables to a Report Multiple Times
• Changing the Join Type for a Link
• Database Changes
• Database Verification
• Set Data Source Location
• Crystal Reports® XI Designer 3 Workshop
• Re-mapping Database Fields
• Views
• Stored Procedures
• Non ODBC Connection Types

6. Running Reports Efficiently

• Understanding What Crystal Can Pass to the Database and How That Affects Report Performance
• Strategies for Efficient Report Performance
• Interpreting the SQL Query
• Using an SQL Statement to Make a Report More Efficient
• Record Selection and Performance
• Performance Information
• Report Definition
• Saved Data
• Processing
• Latest Report Changes
• Performance Timing
• Server Based Grouping
• Requirements for Server Based Grouping
• Select Distinct Command

7. Manual Cross-Tab Reports

• Creating a Cross-Tab Object
• Creating a Cross-Tab without the Expert

8. Tips and Tricks

• Formatting Subreports
• Parameter Tips and Tricks
• Conditional Formatting
• Formatting Page Headers
• Using Fonts to Enhance Readability of your Report
• Windows Character Map
• String Fields and Dates
• Dates Activity

9. OLAP Reporting

• OLAP Explanation
• OLAP Servers
• Creating an OLAP Report
• OLAP Report Formatting