Print this Page

Crystal Reports 7.0: Advanced

Course content
(2 Days)

Review

  • Creating reports

  • Formatting

  • Grouping

  • Summarizing

  • Selecting records

  • Summary Drill Down

  • Linking

  • Formulas

  • Cross-Tabs

Advanced Formulas

  • Creating multiple statement formulas

  • Using variables

  • Understanding two-pass reporting

  • Using evaluation time functions

  • Creating running totals

  • Adding User Functions Libraries (UFLs)

Conditional Formatting

  • Types of formatting

  • Absolute formatting

  • Conditional on/off formatting

  • Conditional attribute formatting

  • Using the highlighting feature

Multiple Sections

  • Inserting sections

  • Splitting Sections

  • Moving sections

  • Deleting sections

  • Multiple section formats (underlay following sections)

  • Example uses (watermark, shading every other record, creating different header/footers, different form letters, suppress blank lines)

Parameter Fields

  • Creating parameter fields

  • Using parameter fields in record selection formula

Advanced Cross-Tabs

  • Multiple rows, columns and summarized fields

  • Formatting Cross-Tabs

  • Using formulas, parameter fields in cross-tabs

  • Simulated Cross-Tabs

Subreports

  • What are subreports?

  • Linked subreports

  • Unlinked subreports

  • On-demand subreports

SQL/ODBC Query Designer

  • What is the SQL/ODBC?

  • What is the Query Designer?

  • What is an ODBC data source?

  • SQL statement components

  • Creating queries

Creating Data Sources

  • Using Access files

Graphing

  • Creating a graph on summary fields

  • Graphing on multiple summary values

  • Graphing on Cross-Tabs

  • Editing and formatting graphs

Dictionaries

  • What are Dictionaries?

  • Using dictionaries to create reports

  • Creating dictionaries

Web Reporting

  • Crystal Web Report server installation

  • Introduction to Web Reporting

  • Viewing Crystal Reports on the Web