Enquiry Form

Duration: 2 Days

Crystal reports 9, 10, 11 or 2008 - Advanced Level

MODULE 1 - Power Formatting with Multiple Sections

• Using Multiple Sections in Reports
• Using the Section Expert to Work with Sections
• Conditionally Formatting Multiple Sections

MODULE 2 - Using the Running Totals Feature

• Understanding Running Totals
• Creating Running Totals for a List of Numbers
• Conditional Running Totals

MODULE 3 - Exporting Your Reports Within your organisation

• Understanding Export Formats and Destinations
• Using an HTML Format for Crystal Reports
• HTML Preview
• Exporting to Windows Applications
• Exporting to a Report Definition Format

MODULE 4 - Setting Default and Report Options

• Setting the Default Layout for Design and Preview Views

MODULE 5 - Using the Report Wizards

• What are the Report Wizards
• Create a Report Using the Standard Report Creation Wizard
• The Data Dialog Box
• The Fields Dialog Box
• The Grouping Dialog Box
• The Summaries Dialog Box
• The Group Sorting Dialog Box
• The Chart Dialog Box
• The Record Selection Dialog Box
• The Template Dialog Box

MODULE 6 - Prompting with Parameters

• Parameter Fields Overview
• Parameter Field Considerations
• Creating a Parameter Field
• Using a Parameter to Select Records
• Using a Parameter Field
• Creating a Parameter with a Dynamic Prompt
• Creating a Parameter with a Cascading List of Values
• Sharing Common Lists of Values within a Report
• Using Separate Value and Description Fields
• Creating a Dynamic Value List for Parameter Values (Version 11 Only)
• Importing a Pick List
• Adding Parameter Values to Text Objects
• Allowing Multiple Values in Parameters
• Using Multiple Parameter Fields in Reports
• Specifying and Limiting a Range for a Parameter
• Using Parameters in Conditional Formatting
• Using an Edit Mask to Limit String Parameters
• Sorting with a Parameter
• Group Sorting with a Parameter
• Using a Parameter to set N in a Top N or Bottom N report
• Displaying Parameter Fields
• Cascading Parameter Fields

MODULE 7 - Using Advanced Formula Features

• Understanding How Crystal Reports Processes the Data
• What Is a Pass
• Using Evaluation Time Functions
• Working with Variables
• Declaring a Variable
• Assigning a Value to a Variable
• Using a Variable in a Formula
• Variable Scope
• Separating Statements in Complex Formulas
• Working with Arrays
• Understanding the Formula Evaluation Time Debugger

MODULE 8 - Using Subreporting as a Workaround Solution

• Understanding Subreports
• Unlinked versus Linked Subreports
• Creating an Unlinked Subreport
• Linking a Subreport
• Database Links versus Subreports in One-to-Many Situations
• Formatting the Subreport
• Passing Data from the Main Report into a Subreport
• Creating On-Demand Subreports
• Creating Hyperlinks
• Using Subreports to Link "Unlinkable" Data

MODULE 9 - Creating Powerful Groups

• Customizing the Group Name Field
• Using a Field Name to Customize the Group Name
• Using a Formula to Customize the Group Name Field
• Creating Custom Groups
• Customizing Group Sort Order
• Grouping on a Formula Field
• Using Group Selection to Filter the Records in the Report
• Grouping Hierarchically

MODULE 10 - Working with Cross-Tab Reports

• Understanding How Cross-Tabs Affect Your Data
• Creating a Cross-Tab Report
• Creating a Cross-Tab with Multiple Rows or Columns
• Applying a Formatting Style to the Cross-Tab
• Customizing the Cross-Tab Format
• Changing Background Colours
• Formatting Individual Cells
• Changing the Summary Operation
• Suppressing Rows, Columns or Totals
• Repeating Row Heading for Multi-Page Cross-Tabs
• Using Alias Names for Column and Row Headings
• Charting Cross-Tabs
• Customizing Cross-Tab Group Names
• CurrentFieldValue

MODULE 11 - Report Alerts

• What are Report Alerts
• Creating Report Alerts
• Basing Report Formulas or Conditional Formatting on Report Alerts
• Creative Usage for Report Alerts

MODULE 12 - Report Templates

• What is a Report Template
• Standard Report Creation Wizard and Templates
• The Template Expert
• Applying a Template and the consequences
• Template Considerations
• Creating Your Own Templates
• Inserting Template Fields
• Formatting Template Fields
• Giving Template Fields a Value