Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Crystal Reports (2008, 2011, 2013): Level 3

New – Learn how to use Crystal Reports to create more complex reports.

GK# 6838

Course Overview

TOP

This course is designed to show you how to create more complex reports. Time will be spent walking you 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.

Schedule

TOP
  • Delivery Format:
  • Date:
  • Location:
  • Access Period:

$

What You'll Learn

TOP
  • Refresher Exercise
  • Advanced Database Concepts
  • Using the Advanced Formula Features
  • Custom Functions
  • Running Reports Efficiently
  • Advanced Cross-Tab Design
  • Tips and Tricks

Outline

TOP
Viewing outline for:

Classroom Live Outline

Refresher Exercise

  • Review of Planning a Report
  • Creating the Report
  • Placing Fields on the Report
  • Advanced Grouping
  • Selecting Certain Records
  • Group Sorting
  • Group Charting

Advanced Database Concepts

  • What is SQL?
  • Native Database Driver
  • ODBC
  • OLE DB
  • ODBC, OLE DB, or Native
  • Using the Database Expert for Linking
  • Adding a Table Multiple Times
  • Changing Join Types
  • Database Changes
  • Database Verification
  • Set Data Source Location
  • Re-mapping Database Fields
  • Views
  • Stored Procedures
  • SQL Commands
  • Creating an SQL Command

Using the Advanced Formula Features

  • Select Case Statement
  • For Loop Control Structure
  • While… Do Loops
  • Do… While Loops
  • Building Arrays
  • The Split Function
  • Array Sizing Limitations

 

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

 

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

Advanced Cross-Tab Design

  • Dissecting a Cross-Tab Grid
  • Cross-Tab Parts Listing
  • Row and Column Indexes
  • Summary Indexes
  • Grid Value Functions
  • Embedded Summaries
  • Conditionally Formatting Embedded Summaries
  • Calculated Members

Tips and Tricks

  • Manual Cross-Tabs
  • Formatting Subreports
  • Parameter Tricks
  • Using Unique Fonts in the Report

Prerequisites

TOP

Successful completion of Crystal Reports®: Level 1 & 2.

Course Delivery

This course is available in the following formats:

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 2 day

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 2 day

Request this course in a different delivery format.
Enroll