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