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


© 1995-2021 Sparta Systems, Inc. All Rights Reserved.
© 1995-2021 Sparta Systems, Inc. All Rights Reserved.Sparta Systems Logo