You can create in-house Crystal Reports in Skills Management by writing your own report queries.
The following parameters allow you to build your report query:
- UserID - use this parameter to pass the current user's Skills Management UID. Using this parameter refines the search such that only the data related to the user is returned.
- TenantID - use this parameter to pass the current user's Tenant UID. Using this parameter refines the search such that only the data related to the Tenant to which the user belongs is returned.
- fnCleanHtml function - use this function to remove the styling tags from formatted text as Crystal Reports doesn't support some of the styling tags. Using this function removes the styling tags from text fields like Assessment Questions and Answers and enables Crystal Reports to display the plain text. The cleaned up text fields are then formatted within the report.
To use the fnCleanHtml function, replace the formatted text field in the report's database query with the following code:
dbo.fnCleanHtml(<database field name>)