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 implementation. 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)