Advanced Crystal Reports XI

Have Queries? Ask us +91 72592 22234

Course Overview

In Advanced Crystal Reports XI Training course, Participants will create complex reports from data sources using SQL statements. They will also learn to create complex formulas and perform loops and conditional logic within a formula. Participants will also learn how to create more sophisticated cross-tabs reports and tips and tricks for using parameters effectively.

Course Content

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-mapping Database Fields
  • Views
  • Stored Procedures
  • Non-ODBC Connection Types

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 and OLAP Report

Customer Reviews

Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.


For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

Looking for a Training for


My Team/Organization

I agree to be contacted over mail or phone

Call us at: +91 7259222234