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

live Chat