Crystal Reports

Crystal Reports Basic: Fundamentals of Report Design

Planning a Report

• Define database concepts
• Plan and develop a report prototype

Creating a Report

• Create a report
• Add tables
• Describe the design environment
• Insert objects on a report
• Preview a report
• Save a report
• Position and size objects
• Format objects

Selecting Records

• Define the Select Expert
• Determine the criteria for record selection
• Understanding saved and refreshed data
• Apply record selection
• Apply additional record selection criteria
• Modify record selection
• Apply time-based record selection

Organizing Data on a Report

• Sort records
• Group records
• Summarize data

Formatting a Report

• Add graphical elements
• Combine text objects with database fields
• Apply specialized formatting
• Insert fields with pre-built functions

Applying Section Formatting

• Format sections
• Create a summary report

Creating Basic Formulas

• Define a formula and its purpose
• Create formulas
• Apply Boolean formulas
• Apply If-Then-Else formulas
• Apply date calculations
• Apply number calculations
• Apply string manipulation

Applying Conditional Reporting

• Determine trends in data
• Format data conditionally

Representing Data Visually

• Create a chart

Distributing a Report

• Export a report
• Save a report to BusinessObjects™ Enterprise
• b): Crystal Reports - Business Reporting Solutions

Using the Repository

• Use the repository
• Create a report from a repository data source

Creating Formulas

• Use functions and operators
• Define control structures available in Crystal Reports Syntax

Managing Reports

• Use the Workbench
• Publish reports to BusinessObjects Enterprise

Using Variables and Arrays

• Use variables
• Use arrays

Using Report Templates

• Apply report templates
• Build a template without a data source
• Remove a template

Building Parameterized Reports

• Define and create parameters
• Build a report with multiple parameters
• Use edit masks and descriptions
• Create a date range parameter
• Group using parameters

Summarizing Data with Crosstabs

• Build a basic crosstab
• Format a crosstab

Using Report Sections

• Use sections
• Use group related functions to format sections
• Use section underlay
• Use multiple-column reporting

Building Specialized Reports

• Use the Running Total Expert
• Create a form letter
• Add a hyperlink to a report
• Use Dynamic Graphic Locations
• Build a report with alerts
• Build a top N report
• Integrate an Xcelsius Flash SWF into a Crystal report
• c) Crystal Reports: Report processing strategies:

Report Processing

• Use multi-pass reporting
• Use evaluation time functions
• Use a dynamic array

Using Subreports

• Define subreports
• Create an unlinked subreport
• Create a linked subreport
• Create an on-demand subreport
• Use shared variables with subreports
• Link “unlinkable” data with subreports
• Describe alternate solutions to using subreports

Creating Complex Formulas

• Use Print State functions
• Use loop control structures
• Use loop control structures with arrays

Using Custom Functions

• Describe a custom function
• Use custom functions

Using XML and Web Services Data

• Use XML and web services data
• Use a transform in XML exporting