Summary
This guide explains how to access, create, and customize the Report by Course List, including template configuration, generation options, and practical use cases for generating detailed course data based on selected course lists.
Introduction
The Report by Course List provides comprehensive and detailed data on student progress across courses included in selected course lists. Each record is shown on a student-course basis, displaying the single latest record for each progress cycle a student has in a specific course. This report is especially valuable for tracking user progress, analyzing training histories, and reviewing user details in-depth. For a complete overview of the Reports section, refer to Reports: An Overview of the Reports Section in LMS.
Steps to Follow
How to Create a Custom Report by Course List Template
The Report Generation tab contains predefined templates that come with your KnowledgeCity LMS, along with any custom templates you have previously created. If the default Report by Course List template meets your needs, you can run it directly. To create a new custom template with specific fields and settings, follow the steps below.
Navigate to Reports > New Report Template.
From the Report type dropdown, select Report by course list.
When you select Report by Course List as the report type, the system automatically populates default fields, along with default template name, language, description, and title style, all of which you can customize to suit your needs.
Configure your template:
Field | Description |
|---|---|
Template name | Specify a unique name (e.g., "Q1 Course List Progress Report") |
Template language | Select the preferred language for report output |
Description | Provide a brief description (up to 500 characters) to clarify the report's purpose |
Title style | Format the report title using bold, italic, underline, font size, alignment, and title text and background color options |
Include portal logo | Toggle to add your portal logo to the report output |
Default Fields in This Report
Groups: Group path showing hierarchical structure.
Group: The user group(s) the user belongs to.
User Name: The user's unique login identifier.
Date of Birth: The user's birth date.
Course ID: Unique identifier for the course in the LMS.
Course Name: Official name of the course.
Name of the course list: Official name of the course list associated with it.
Begin: Date when the user started the course.
Begin time: Time when the user began the course session.
Watched: Date when the user fully viewed all course content.
Watched time: Time when the user completed viewing all course content.
Passed: Date when the user successfully passed the course.
Passed time: Time when the user met the criteria to pass.
Course status: Current status: Not Started, In Progress, Viewed, or Passed.
Score: Score achieved on the certification quiz.
Certificate: Unique certificate number issued upon course completion.
Original assignment date: Date when the course, course list, or learning path was originally tied to the user.
Assignment date: Date when the course, course list, or learning path was assigned or reassigned.
Learning Path Name: Name of the learning path that delivered the course.
Availability Start: Date when the course became available to access.
Availability End: Date when the course is no longer accessible.
Assigned through: Indicates whether the course was assigned individually or through a user group.
You can modify these defaults or add additional fields to tailor the report to your requirements. For detailed descriptions of all available fields, refer to Report Fields: A Complete Reference Guide for All Reports.
Customize columns using the rows adjustment section:
Click Add column to include additional fields.
Drag and drop columns to reorder if required.
Click the Edit button on any column to format, style, or add conditional rules.
Click the Delete button to remove columns.
For detailed instructions on managing columns, refer to Report Templates: How to Manage Columns with Rows Adjustment and Formatting.
Click Save template.
How to Generate the Report by Course List
Navigate to Reports > Report Generation.
Locate your newly created Report by Course List template.
Click Run report.
The Run report button opens a configuration window where you can set the following parameters before generating the report:
Option | Description |
|---|---|
Group | Select which user group to include or All groups |
Exclude disabled users | Toggle to remove inactive users from the report |
Time Zone | Choose the time zone for date calculations |
Select a course list | Filter to a specific course list (a course list selection dropdown appears upon selection) |
Learning path | Filter to a specific learning path (a learning path selection dropdown appears upon selection) |
Select a course | Filter to a specific course (a course selection dropdown appears upon selection) |
Individually assigned courses | Toggle to show courses assigned individually to users |
As of | Select a specific date to generate report as of that point in time |
Not Started / In Progress / Viewed / Passed | Checkboxes to filter by progress status (multiple selections allowed) |
Include Previous Course Cycles | Toggle to show earlier attempts for the same course |
Include not assigned courses | Toggle to include courses where users have activity but no formal assignment |
Include archived students | Toggle to include achieved users in the report |
Click Create and proceed to the Reports tab, locate your report on the top of the list and click the Download button to export.
Example Use Cases
Track training history for certification programs: Select a course list that represents a certification program. Run the report to see detailed progress for each learner across all courses in the program, including start dates, viewed dates, passed dates, and scores.
Analyze assignment sources: Review the Assigned through column to identify whether courses came from group assignments, individual assignments, or learning paths. This helps audit how training is being delivered.
Conclusion
You have successfully learned how to generate and customize the Report by Course List. This report provides comprehensive and detailed data on student progress across courses included in selected course lists, with each record shown on a student-course basis. By creating custom templates with the fields that matter most, you can efficiently track user progress, analyze training histories, and review user profile details in-depth.