• 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

    • Working with TrackWise UDF fields
    • Working with TrackWise external fields
    • Working with multiple PR tables
    • 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
    • Evaluation time of formulas (understanding record processing before reading, while reading, while printing)
    • 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