Crystal Reports Designer 2013/2016 Level 3

Unlock the power of dynamic data presentation with our advanced Crystal Reports Designer 2013/2016 Level 3 course, tailored for administrators, developers, and end-users seeking to master complex report creation and data-driven insights.

Course Thumbnail

Essential Skills Gained

Checkmark

Expand your knowledge of Crystal Reports with advanced reporting techniques.

Checkmark

Create custom functions and advanced formulas for efficient data handling.

Checkmark

Enhance report performance by understanding and implementing SQL commands and database concepts.

Checkmark

Apply tips and tricks to enhance report design and functionality.

Format

  • Instructor-led
  • 1 days with lectures and hands-on labs.

Audience

  • Administrators
  • Developers
  • End-users creating dynamic reports

Description

This two-day workshop is designed to expand your working knowledge of Crystal Reports® and move you into creating 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 functions, advanced formulas and report inefficiencies techniques. This course incorporates a number of hands on exercises that reinforce the learning process.

Calendar icon

Upcoming Course Dates

No upcoming dates. Please check back later.

Course Outline

Download PDF

Refresher Exercise

  1. Review of Planning a Report

  2. Creating the Report

  3. Placing Fields on the Report

  4. Advanced Grouping

  5. Selecting Certain Records

  6. Group Sorting

  7. The Report Header

  8. The Group Chart

Custom Functions

  1. What is a Custom Function

  2. Custom Function Arguments

  3. When to use a Custom Function

  4. Creating Custom Functions

  5. Creating a Custom Function using the Custom Function Editor

  6. Using Crystal Syntax

  7. Using Basic Syntax

  8. Properties Using the Formula Expert

  9. Using the Formula Extractor

  10. Custom Function Limitations

Using Advanced Formula Features

  1. Advanced Formula Syntax Review

  2. Expressions Alternatives to the IF THEN ELSE Function

  3. Select Case Statement

  4. Immediate If Function

  5. IIF (expression, truePart, falsePart)

  6. For Loops

  7. Exit For

  8. While Do Loops

  9. Join Function

  10. The Split Function

  11. Crystal Formula Sizing Limitations

Crystal Reports, Data Access and SQL

  1. What is SQL?

  2. Direct Database Driver

  3. ODBC

  4. OLE DB

  5. Viewing the SQL

  6. SQL Commands

  7. Creating a SQL Command

  8. Adding a Parameter to the Command

  9. SQL Expressions

  10. Creating a SQL Expression

Advanced Database Concepts

  1. Using the Database Expert for Linking

  2. Order Links Dialog

  3. Index Legend Dialog

  4. Link Options Dialog

  5. Adding and Removing Databases/Tables from the Report

  6. Adding Tables to a Report Multiple Times

  7. Changing the Join Type for a Link

  8. Database Changes

  9. Database Verification

  10. Set Data Source Location

  11. Re-mapping Database Fields

  12. Views

  13. Stored Procedures

  14. Non ODBC Connection Types

Running Reports Efficiently

  1. Understanding What Crystal Can Pass to the Database and How That Affects Report Performance

  2. Strategies for Efficient Report Performance

  3. Interpreting the SQL Query

  4. Using an SQL Statement to Make a Report More Efficient

  5. Record Selection and Performance

  6. Performance Information

  7. Report Definition

  8. Saved Data

  9. Processing

  10. Latest Report Changes

  11. Performance Timing

  12. Server Based Grouping

  13. Requirements for Server Based Grouping

  14. Select Distinct Command

Manual Cross-Tab Reports

  1. Creating a Cross-Tab Object

  2. Creating a Cross-Tab without the Expert

Tips and Tricks

  1. Formatting Subreports

  2. Parameter Tips and Tricks

  3. Conditional Formatting

  4. Formatting Page Headers

  5. Using Fonts to Enhance Readability of your Report

  6. Windows Character Map

  7. String Fields and Dates

  8. Dates Activity

OLAP Reporting

  1. OLAP Explanation

  2. OLAP Servers

  3. Creating an OLAP Report

  4. OLAP Report Formatting

Your Team has Unique Training Needs.

Your team deserves training as unique as they are.

Let us tailor the course to your needs at no extra cost.