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 forcing 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 functionality 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, hierarchical 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