• Crystal Reports Design for TrackWise®   

    Prerequisites: Sparta Systems recommends Introduction to TrackWise or previous TrackWise experience/Technical Fundamentals of TrackWise/Introduction to Configuration and Administration

    Audience: Any person who will be designing and developing Crystal Reports for their TrackWise implemen­tation. This may include Project Managers, Team Members, Power End Users, Application Administrators, IS Support Personnel.

    Duration: 4 Days

    Course Description

    The Crystal Reports Design for TrackWise course is intended to provide report writers a basic understanding of the Crystal Reports application and the TrackWise database structure. This hands-on course includes the creation of sample reports for a TrackWise implementation. A strong emphasis is placed on FDA-regulated industry examples and usage in a cGxP-regulated environment.

    Course Topics/Outline

    • Update schema/creation of views
    • Table linking and schema overview
    • Tabular reports
    • Single-record reports
    • Parent-Child reports
    • Multi-field reporting
    • User-defined fields in reports
    • Parameters
    • Headers/Footers/Typical cGxP Compliance concerns
    • Select expert
    • Grouping (group by formulas)   
    • Formulas (data manipulation)
    • Running totals
    • Cross tabulations
    • Charts (graphing)
    • Trend reporting
    • GMT Conversion/Skew
    • Activity History
    • Configuration reports (provided by Sparta Systems)
    • Troubleshooting reports
    • Report validation and promotion
    • Directory security/Permissions
    • Coordinator integration (AutoReports)
sU tcatnoC