Corporate Training in Crystal Report 11

Crystal Reports is designed to work with your database to help you analyze and interpret important information. Crystal Reports makes it easy to create simple reports, and, it also has the comprehensive tools you need to produce complex or specialized reports.

Crystal Report is a reporting tool, which supports 25 databases to create impressive reports, lists, form letters, pre-printed forms, or labels from data in your existing databases. Crystal Reports can produce reports by picking up data from various data sources, such as: Oracle, Informix, Sybase, Microsoft SQL Server, dBase, Clipper, FoxPro, Access, Lotus Notes, SAP, etc.

The flexibility of Crystal Reports doesn't end with creating reports; reports can be published in a variety of formats including Microsoft® Word and Excel, E-mail and even over the Web. Advanced Web reporting let's other members of the workgroup view and update shared reports inside their web browser.

Application and web developers can save time and meet their users needs by integrating the report processing power of Crystal Reports into their database applications. Support for most popular development languages makes it easy to add reporting to any application.

Course Content

Module 1: Simple Report

Report creation options.
Selecting the Database to use
Saving the Report
Adding a title to the report
Formatting the report objects
Format Painter
Adding date to the report
Adding Page Numbers to the report
Adding Picture or OLE Objects to the report.

Module 1: Record Selection

Using the Select Expert .
Deleting a criteria

Module 2: Sorting Data

Sorting single and multiple fields

Module 3: Group by Report

Grouping Data
Grouping on Date field
Creating custom groups
Hierarchical Grouping
Summarizing grouped data
Top or bottom N groups or Percentages

Module 4: Summary Reports


Introduction

Creating a Summary Report

Hide vs. Suppress

Module 5: Using Sections and Areas


Introduction .

Changing the size of a section

Formatting Sections with the Section Expert

Module 6: Linking


Introduction

Working with Links

Using the Visual Linking Expert

Smart Linking

Adding/Removing Database from a Report

Module 7: Formula Basics

Introduction
Typical uses for formulas
Creating a formula and inserting it into a report
Copying formulas from one report to another
Deleting formulas
Crystal Syntax versus Basic Syntax

Module 8: Custom Functions

What are custom functions? .
Working with custom functions
Viewing and modifying custom functions
Calling custom functions
Adding custom functions to the Crystal Repository
Adding custom functions from the Crystal Repository
Refreshing a report's repository custom functions
Example of a function that returns Quarter using Crystal Syntax

Module 9: Crystal Repository

Configuring a new repository
Accessing the sample Crystal Repository
Using repository objects in reports

Module 10: Parameter overview


Parameter field considerations

Creating a parameter field .

To incorporate the parameter into the selection

Refreshing report data .

Module 11: Running Totals


Understanding running totals

Creating a running total in a list

Creating running totals for a group

Creating conditional running totals

Module 12: Conditional Formatting


Introduction

Absolute Vs Conditional Formatting

Conditionally Formatting Fields and Objects

Module 13: About Report Alerts


Creating Report Alerts

Module 14: Cross-Tab Objects


Introduction

Creating a Cross-Tab Object

Formatting Cross-Tabs

Module 15: Graphing

Introduction
Creating a Simple Graph .

Module 16: Subreports


What are subreports?

Unlinked vs. linked subreports

Inserting subreports

Saving a subreport as a primary report

Updating subreports

Creating an on-demand subreport

Adding captions to on-demand subreports

Module 17: Report Distribution


Introduction

Export Formats

Export Destinations

Faxing a report

Module 18: Tips working with Crystal Reports

Page Title on Drill down Reports
Repeating Group Headers
Creating Formula with Parameter for Report Header
Inserting Page Break after every 20 records
Creating a Page Total in Crystal