Course Code: 5417

Crystal Reports 2013 Designer 3 Workshop

Class Dates:
12/26/2018
2/27/2019
Length:
2 Days
Cost:
$695.00
Class Time:
Technology:
Business
Delivery:

Overview

  • Course Overview
  • This 2-day course covers the more complex and powerful features of Crystal Reports.

  • Audience
  • Experienced administrators, developers and end-users who are experienced with Crystal Reports.

Prerequisites

Course Details

  • 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
  • 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
  • When to use a Custom Function
  • 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