Skip to main content

Create a new report column

In this article, we explain how to create a new report column

Donna Parker avatar
Written by Donna Parker
Updated over a month ago

Report columns are the training subjects that make up your compliance report. They track your staff's training compliance around eLearning courses, in-house training, or a combination of both, depending on how many ways your staff can obtain their training qualifications.

Create a new report column

Follow these steps to set up a custom report column.

⚠️Important: You'll need certain permissions to create report columns, raise a support case if you need access.

Create the column

First, create the column.

  1. Sign in to the Admin Tool.

  2. Click Config.

  3. Click Reporting Columns.

  4. Click the add icon

  5. Type in the name of the new column in the description and click Save.

Configure the column

Next, configure the column rules.

  1. Click the column you just created to expand it.

  2. Click the add icon to the right of the Include box.

  3. Select courses, training records, events, or any other items you want to include, then click Add.

    πŸ€“Tip: If you need to create a new training record description, see this article.

  4. In the Completion and Result box, select Result Type.

  5. Select CareReportStatus.

  6. Select Rule Type, then select Mandatory or Allocated.

  • Mandatory if the training needs to show as a requirement, regardless of completion or not.

  • Allocated if data should only populate on the report when the course is assigned or a training record is added to the user.

7. Select Completion Period, then select the number of days. This is the period shown as In completion.
8. Select Completion Period From, then select when the completion period needs to be calculated from.

  • Assign date: The date from when a course or training was assigned to a user.

  • Create date: The date on which a user account was created.

  • Start date: The start date of a user.

  • Date range: A date range of when the course was assigned.

Include user groups

Finally, include the user groups that govern who needs to do the training associated with the report column.

  1. Scroll down to the User Groups box, then click the add icon.

  2. Search for the user group you want to link to the column. See this article if you need to create a new user group.

  3. Click Add.

  4. Click Save.

πŸ€“Tip: For your new column to appear on a report, you'll need to include it in the report it needs to show in, along with the associated user group. See this article for steps on how to do this.

Did this answer your question?