Corporate Training in Crystal Report 11

COMPUFIELD® Computer Institute
In Mumbai

Price on request
Compare this course with other similar courses
See all

Important information


Important information

Where and when

Starts Location
On request
OPriya Bldg.,1st Floor, Dr. Peter Dias Road, Near Mehboob Studio,, 400050, Maharashtra, India
See map
On request
Chinoy Mansion, First Floor, Block #2, Opp. St.Stephen's Church, Warden Road,, 400036, Maharashtra, India
See map

Course programme

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


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


Working with Links

Using the Visual Linking Expert

Smart Linking

Adding/Removing Database from a Report

Module 7: Formula Basics

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


Absolute Vs Conditional Formatting

Conditionally Formatting Fields and Objects

Module 13: About Report Alerts

Creating Report Alerts

Module 14: Cross-Tab Objects


Creating a Cross-Tab Object

Formatting Cross-Tabs

Module 15: Graphing

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


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

Compare this course with other similar courses
See all