Advanced Crystal Reports Design for TrackWise

Prerequisites: Crystal Reports Design for TrackWise
Audience: Recommended 1+ years experience developing Crystal Reports
Duration: 3 Days

Course Description

The Advanced Crystal Reports Design for TrackWise course is designed to expose report writers to advanced functionality in the Crystal Reports application while focusing on business-specific TrackWise scenarios.

Course Topics/Outline

  • Definition and utilization of external fields
  • Utilization of direct table linking related to multi-field  user defined fields
    -  Grid fields
    -  Reference records
  • Understanding single and multi-record reports filtering mechanism
  • Advanced formulas and functions, including:
    -  Built in functions
    -  Summary functions
    -  If-Then-Else logic
    -  Shortcuts
    -  Creating custom functions
  • Evaluation time of formulas (understanding record processing before reading, while reading, while printing)
  • Advanced cross-tabulation techniques (including forc­ing text labels for multi-row summary, conditional formatting, cross-tab mimic with multiple column formatting)
  • Advanced charting (including drill-down reports, dual-axis charts, Top N charts, underlay functional­ity with charts)
  • Formatting tips & tricks (including hyperlinking to PR records, alternating background colors, repeated group headers, subreports)
  • Multi-pass reporting
  • Cycle time, workflow and rolling date reports
  • Grouping & sorting (including specified order, hier­archical grouping, summary functions)
  • Variables (including running totals, shared variables, and filtering subreports to display related data content, reinitializing based on grouping)
  • Formulas & functions (including concentration on built-in functions and creating custom functions)
  • Control Structures—Select Case and For Loop Logic
  • Arrays and Ranges—Subscripting, Variables, Logic Construct
© 1995-2016 Sparta Systems, Inc. All Rights Reserved.
© 1995-2016 Sparta Systems, Inc. All Rights Reserved.Sparta Systems Logo