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