Crystal Reports 2008 Designer Level 3

Course CodeCR-202
VendorCrystal Reports
CategoryCrystal Reports
PDF File


Click & Enroll

Date Range
Thu, May 22 - Fri, May 23
Mon, Nov 24 - Tue, Nov 25

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 efficiencies 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