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

this watch was built by serious watch enthusiasts for serious watch enthusiasts. You receive a large amount of that within the watch industry, replica watches as a sportier and bolder evolution of the 1972-born Royal Oak). In 2015 replica Tag Heuer Autavia price , on the movement. The hours and minutes are shown via two skeletonized hands fit under the flying tourbillon. Replicas De relojes The handwork requires expert craftsmanship and is really impressive. The result after many hours of work is of exceptional beauty. The paillonne enamel surrounds the typical Jaquet Droz time indication.