Course Name

Crystal Reports XI Intermediate (2 days) Class

Printable Version

Overview

Upon successful completion of this course, students will be able to:

  • Create running totals in a report.
  • Build cross-tabs in your report.
  • Subreports to a report.
  • Design a report that uses a drill-down.
  • Improve processing speed in your reports.
  • Chart single and multiple data series.
  • Report from Excel data.
  • Implement report prompts.
  • Enhance report functionality.

Course Content
    Lesson 1: Creating Running Totals
    Create a Running Total Field
    Modify a Running Total Field
    Create a Manual Running Total on Detail Data
    Create a Manual Running Total on Summary Data

    Lesson 2: Building Cross-tabs in Your Report
    Create a Cross-tab
    Create a Specified Group Order
    Filter a Cross-tab by Group
    Change the Cross-tab Format
    Conditionally Format Rows and Columns
    Keep Groups Together

    Lesson 3: Adding Subreports
    Insert a Subreport
    Link a Subreport to a Primary Report
    Edit a Subreport's Structure
    Format a Subreport Using the Format Editor
    Share Variables Between Subreports and Primary Reports
    Create an On-demand Subreport

    Lesson 4: Creating Drill-downs
    Create a Drill-down
    Create Separate Headings for Drill-down Data

    Lesson 5: Enhancing Report Processing by Writing SQL Statements
    Create a Report Using SQL Queries
    Summarize Report Data Using SQL Aggregate Functions
    Create Joins Using SQL
    Create Subqueries
    Create a SQL Expression Field

    Lesson 6: Charting Data
    Create a Bar Chart
    Modify a Chart
    Format a Chart
    Create a Chart Template
    Create a Top N Chart
    Create a Cross-tab Chart

    Lesson 7: Reporting on Excel Data with Crystal Reports
    Create a Report Based on Excel Data
    Modify a Report Generated from Excel Data
    Update Data in a Report Based on Excel Data

    Lesson 8: Working with Prompts
    Create a Static Prompt
    Create a Dynamic Prompt

    Lesson 9: Enhancing Report Functionality
    Group Data Hierarchically
    Create a Dynamic Image
    Create a Report Alert
    Create a Geographic Map

    Appendix A: Understanding BusinessObjects Enterprise

    Appendix B: Understanding Report Templates and the Section Expert

    Appendix C: Report Data Manipulation Techniques