UMBC Training Centers logo

Crystal Reports XI Designer 3 Workshop

 

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