Crystal Reports Designer Level 2 CR-02B

Module 1Refresher Exercise

• Review of a planning report
• Creating the report
• Placing fields on the report
• Creating the formulas
• Advanced grouping
• Selecting certain records
• Helpful hints for formatting the report
• Adding and working with text objects
• Hiding and suppressing sections
• Guidelines

Module 2Power Formatting with Multiple Sections

• Using multiple sections in reports
• Using the section expert to work with sections
• Conditionally formatting multiple sections

Module 3Using the Running Totals Feature

• Understanding running totals
• Creating running totals for a list of numbers
• Conditional running totals

Module 4Prompting with Parameters

• Parameter field considerations
• Creating a parameter field
• Using a parameter to select records
• Using a parameter field
• Using the parameter panel
• Creating a dynamic value list for parameter values
• 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
• Using parameters in conditional formatting
• Using an Edit Mask to limit string parameters
• Sorting with a parameter
• Using a parameter to set N in a top N report
• Cascading parameters

Module 5Using 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 Evaluation Time Debugger

Module 6Using Sub reporting as a Workaround Solutions

• Understanding Sub reports
• Unlinked versus Linked Subreports
• Creating an Unlinked Sub report
• 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 7Creating Powerful Groups

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

Module 8Working 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 Colors
• 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
• Using the CurrentFieldValue Function

Module 9Report Alerts

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