Skip to content
Mint Service Desk Documentation centre

Creating Report

Configure a report by selecting its data, fields, filters, access roles, export settings and recipients. The examples cover a ticket report and a report based on an SQL query.

Click the button shown below to create a report.

The ‘Create report’ view opens.

Report data and access

Choose the data to include in the report:

  • Tickets
  • Assets
  • Users
  • Contracts
  • SQL

The selected report type determines which fields and filters are available. Some fields, such as those in a ticket report, are selected by default. You can change this set.

The next section is “Can view”

Select the roles that may view this report.

The Filters section is below.

You can keep the default filters or change them. Each filter requires its corresponding field.

Removing the ‘Ticket type’ field also removes its filter. You can add a field without adding a filter. To add a filter, click Add filter.

Filters

In the drop-down list, after the basic fields, there is a section with custom fields.

Hover over a custom field to see its Ticket Type and Group.

The same information is available after you select a custom field.

In Export, choose the file format in ‘Export type’ and the language in ‘Default language’ to enable report downloads.

The Report groups section below Export groups tickets or assets by your chosen criteria. You can add up to five items.

Example of a report using Report groups:

In Report recipients, select who should receive the report by email.

You can click on button and select from the list of saved recipients:

Alternatively, click to add an email address.

Example: a ticket report

After filling in all the fields, click the button. The report configuration is now ready for generating a new report.

The following example creates a report for all tickets:

  • assigned to ‘Mint Agent’
  • created within the current week,
  • having ‘In progress’ status,
  • owned (created) by ‘MINT Customer’ user.

Select the report type in ‘Please select the type of report you want’.

Enter a ‘Name’, such as “Urgent Tickets”, in the lower part of the view. In ‘Fields’, choose the columns to include or keep the defaults.

Click ‘X’ next to a field to remove it. In this example, remove ‘Ticket type’.

The ‘Ticket type’ filter is also removed. Add a field and filter for the condition “owned (created) by ‘MINT Customer’ user”.

To add a new field click on the field located below.

Select ‘Company user’ from the list of available fields. You can add further fields while unselected items remain in the list.

The selected field appears in ‘Fields’.

To add a company user filter, click below the selected filters.

From the newly created ‘Filter fields’ list select ‘Company user’.

Click to add the filter, or to cancel.

The filter appears in the list.

Set the filters to find tickets:

  • assigned to ‘Mint Agent’
  • created within the current week,
  • having ‘In progress’ status,
  • owned (created) by ‘MINT Customer’ user.

Select the filter values shown below.

To remove a selected value, click ‘X’ next to its name. The ‘X’ on the right of a filter clears all its selected values.

The first method is used for deleting single position, while the second one will delete all of the selected options for the filter.

The report cannot yet be saved with ‘Save’: unused filters are outlined in red.

Delete those filters you don’t want to use by clicking button next to each of them.

Click button to create the report. Once you do that you will see a new position on the list in the ‘Report definitions’ view.

To change a saved report, click to open ‘Edit report’.

To delete the report, click and confirm with ‘Yes’.

SQL Reports

SQL Reports lets you query the Reports module database directly. Mint Service Desk displays the available records from the selected table. You can also email the generated report to a selected address.