Crystal Reports Designer 2008/2011/2013 Level 3

Course CodeCR-202
VendorBusiness Applications
CategoryCrystal Reports
PDF File
  
Days2
Centriq Vouchers2
Retail Price$900.00


Click & Enroll

Date Range
Mon, Jul 06 - Tue, Jul 07
Mon, Nov 23 - Tue, Nov 24

Need a date you don't see here?

Request a date




Introduction

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.


Audience

The primary audience for this course is as follows:

  • Administrators
  • Developers
  • End-users who need to create dynamic reports from varying data sources

At Course Completion

     


Prerequisites

The knowledge and skills that a learner should have before attending this course are as follows:

  • Successful completion of the Designer 1 and Designer 2 Workshops is strongly recommended

Course Outline

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

Advanced Database Concepts

  • What is SQL?
  • Native Database Driver
  • ODBC
  • OLE DB
  • ODBC, OLE DB or Native
  • Using the Database Expert for Linking
  • Order Links Dialog
  • Index Legend Dialog
  • Link Options
  • Adding Tables to a Report Multiple Times
  • Changing the Join Type for a Link
  • Database Changes
  • Database Verification
  • Set Datasource Location
  • Re-mapping Database Fields
  • Views
  • Stored Procedures
  • SQL Commands
  • Creating a SQL Command
  • Adding a Parameter to the Command

Using Advanced Formula Features

  • Alternatives to the IF THEN ELSE Control Structure
  • Select Case Statement
  • Using the For Loop Control Structure
  • The Different Types of While Loops
  • While … Do
  • Do … While
  • Building Arrays
  • The Split Function
  • Crystal Formula Sizing Limitations

Custom Functions

  • Custom Function Arguments
  • When to Use a Custom Function
  • Creating Custom Functions
  • Creating a Custom Function Using the Custom Function Editor
  • Custom Function Properties
  • Using the Formula Expert and Custom Functions
  • Using the Formula Extractor
  • Custom Function Limitations

Running Reports Efficiently

  • Understanding What Crystal Can Pass to the Database
  • Strategies for Efficient Report Performance
  • Interpreting the SQL Query
  • Using a SQL Expression to Make a Report More Efficient
  • Record Selection and Performance
  • External Joins
  • Performance Information
  • Report Definitions
  • Saved Data
  • Processing
  • Latest Report Changes
  • Performance Timing
  • Server Based Grouping
  • Requirement s for Server Based Grouping
  • Select Distinct Command

Advanced Cross-Tab Design

  • Introduction to 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
  • Cross-Tab Calculated Members Expert

Tips and Tricks

  • Creating a Cross-Tab With the Expert
  • Formatting Subreports
  • Parameter Tips and Tricks
  • Conditional Formatting
  • Using Fonts to Enhance Readability of Your Report
  • Windows Character Map

Appendix A - Setup Instructions for Crystal Reports 2008

  • Crystal Reports 2008 Application Installation Instructions
  • Installing Required Class Files

Appendix B - Setup Instructions for SQL Server 2005 Express Edition

  • Installing SQL Server 2005 Express Edition
  • SQL Server 2005 Expression Edition Installation Instructions
  • Installing the AdventureWorks Database
  • Attaching the AdventureWorks Database

Appendix C - The AdventureWorks Database