• 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
sU tcatnoC