SAP Crystal Reports - Advanced Training

PDF

Crystal Reports - Advanced

• Power Formatting with Multiple Sections
  • Using Multiple Sections in Reports
  • Using the Section Expert to Work with Sections
  • Conditionally Formatting Multiple Sections
• Using the Running Totals Feature
  • Understanding Running Totals
  • Creating Running Totals for a List of Numbers
  • Conditional Running Totals
• Prompting with Parameters
  • Parameter Fields Overview
  • 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
  • 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
• Using Advanced Formula Features
  • Understanding How Crystal Reports Processes Data
    • What is a Pass?
    • Pre-Pass #1
    • Pass #1
    • Pre-Pass #2
    • Pass #2
    • Pass #3
    • 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
• 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
• Creating 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
• 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 the Summary Operation
  • Charting Cross-Tabs
  • Customizing Cross-Tab Group Names
  • CurrentFieldValue
• Report Alerts
  • What are Report Alerts?
  • Creating Report Alerts
  • Basing Report Formulas or Conditional Formatting on Report Alerts
  • Creative Usage for Report Alerts

Before Taking this Class

Software/Setup For this Class

• SAP Crystal Reports Professional
• Microsoft Office