# Report Management

## Overview

Forma LMS provides a powerful and flexible report generation system, with these features:

- Create unlimited custom report
- Report generation wizard
- Automatically filter reports for assigned users and course
- Scheduling

[![image.png](https://docs2.formalms.org/uploads/images/gallery/2024-02/scaled-1680-/Nvlimage.png)](https://docs2.formalms.org/uploads/images/gallery/2024-02/Nvlimage.png)

**Public**: when a report is flagged as “public” it will be visible to all administrators and superadministrators. Non public reports can be viewed only by superadministrators and by the administrator that created the report

**View**: view the report

**Export** in CSV or XLS format

**Schedule** the report to be automatically sent by email to selected users

**Edit**: modify configuration options for the report

<p class="callout info">**NOTE**: Users with level **Administrator** will be allowed to see and edit onlyy report flagged as “public”, or created by themselves. Within the reports, administrator will see users and courses based on their user assignements. See [Administrators management guide](https://docs.formalms.org/reference-guide-2/user-management/administrators.html) for details</p>

## Create Reports

A four-steps wizard will guide you in report creation:

1. Select the report category
2. Select filter on the rows to display or data aggregation mode
3. Select the report type: please note that it won't be possible to change the report type once saved
4. Select column and criteria for the selected report type

## Report Category

Forma natively provides three report “categories”, each based on a different logic for data displaying, and providing different report types.

Available categories are:

1. Users-Courses: will display different data type for a list of users.
2. Courses-Users: will display different data type for a list of courses.
3. Aggregated: shows aggregated information for selected users and courses

[![image.png](https://docs2.formalms.org/uploads/images/gallery/2024-02/scaled-1680-/c1kimage.png)](https://docs2.formalms.org/uploads/images/gallery/2024-02/c1kimage.png)

## User Selector

For each category, it is possible to select the users to be included in the report.

In most cases, the best option is including “all users” and simply filter by course:

[![image.png](https://docs2.formalms.org/uploads/images/gallery/2024-02/scaled-1680-/Sokimage.png)](https://docs2.formalms.org/uploads/images/gallery/2024-02/Sokimage.png)

## Report Scheduling

Reports can be automatically generated and sent by email to some users

You can create an unlimited number of schedules:

[![image.png](https://docs2.formalms.org/uploads/images/gallery/2024-02/scaled-1680-/pihimage.png)](https://docs2.formalms.org/uploads/images/gallery/2024-02/pihimage.png)

Upon schedule creation and edit, it will be possible to choose the users that will receive the report and set the date/frequency and time with the following settings:

[![image.png](https://docs2.formalms.org/uploads/images/gallery/2024-02/scaled-1680-/YSLimage.png)](https://docs2.formalms.org/uploads/images/gallery/2024-02/YSLimage.png)

### Advanced Settings (Report Attachment)

Further settings to configure how the scheduled report might be attached to the sent email can be configured under:

 Adm &gt; Settings &gt;System Configurations &gt; Settings &gt; Advanced

[![advanced_report_settings.PNG](https://docs2.formalms.org/uploads/images/gallery/2024-10/scaled-1680-/advanced-report-settings.PNG)](https://docs2.formalms.org/uploads/images/gallery/2024-10/advanced-report-settings.PNG)

<p class="callout info">Set the "Max attached report size" according to your intranet or email account limits.   
If value is set to zero, users will always receive a link to the stored file.</p>

### Cron setting

For the file to be sent, you will need to set up a cron-job on your server, calling the file:

<span style="background-color: rgb(206, 212, 217);">*\[root\]/cron/cron.report.php*</span>