• 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

    • Reporting overview
    • Integration with TrackWise Web and database connectivity
    • Linking tables using joins
    • Adding tables to a report
    • Designing multi record reports
    • Grouping and sorting data within reports
    • Utilizing running totals within a report
    • Utilizing parameters to control report content
    • Utilizing formulas to manipulate, control and calculate data
      -  Date and time conversion
      -  Swapping two columns of data
      -  Calculate number of days open
      -  Conditional display of data
      -  Use of break groups to separate data
      -  Management of null data result display
    • Utilizing headers and footers (including headers and footers for GxP compliance)
    • Development of charts and graphs
    • Utilizing cross tabs for matrix development
    • Utilizing the Select Expert tool to further refine  data set results
    • Creating single record reports
    • Creating of sub-reports
    • Developing an activity history report for audit trail review on a record
    • Reporting on a family of records using parent-child reports
    • Converting reports from one database to another
    • Creating auto reports for scheduled distribution
    • Troubleshooting reports
    • Discuss the impact of configuration changes on reports via Views
    • Discuss report validation
sU tcatnoC