# Creating Report · Reports · Agent Portal · User Interface

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.

Canonical: https://docs.mintsd.com/docs/mint-service-desk/web-interface-creating-report
Language: en-GB
Revision: 2a2d39f1e31deba465d9905cd685a5a3416966a588eb6151bba19ba5bc3c7cc9

<a id="element-01a1452d-f577-71a9-8ae7-04af0d66e2b0"></a>

Click the button shown below to create a report.

<a id="element-01a1452d-f578-7b09-83b6-2ba84b97757e"></a>

![Creating Report: Click the button shown below to create a report.](https://docs.mintsd.com/api/reader/assets/assets/images/image210.png?v=9df3302a5f39f38c56be5e0231527d4dbdac36b8c4ebf6b5e2b95f6bf4630b1e)

<a id="element-01a1452d-f578-7de4-9a71-d5d0ee255023"></a>

The ‘Create report’ view opens.

<a id="element-01a1452d-f579-7a44-bdb0-9f75d1de1dc6"></a>

![Creating Report: The ‘Create report’ view opens.](https://docs.mintsd.com/api/reader/assets/assets/images/image211.png?v=ed3c7accaba01e2615589ae42ee7b0801e775607a7aa57b32ed4d0e0b3762e49)

<a id="element-01a1452d-f579-785a-968f-b3484876ebf3"></a>

## Report data and access

Choose the data to include in the report:

<a id="element-01a1452d-f57b-7ef1-87ae-5343465d9cb8"></a>

- Tickets
- Assets
- Users
- Contracts
- SQL

<a id="element-01a1452d-f57b-7dc8-9c46-c704ce363a34"></a>

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.

<a id="element-01a1452d-f57b-7f2f-8414-1122cf6051a0"></a>

![Creating Report: 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.](https://docs.mintsd.com/api/reader/assets/assets/images/image212.JPG?v=f3a64969877d06cacb8d4f0290294a6d05d1151fab8d9de47778e37fe314abc1)

<a id="element-01a1452d-f57c-779a-a7b2-1f6510b99803"></a>

The next section is “Can view”

<a id="element-01a1452d-f57c-7aba-8f40-4aff88189e80"></a>

![Creating Report: The next section is “Can view”](https://docs.mintsd.com/api/reader/assets/assets/images/image1096.png?v=f069c91b05ac32da4f11f605e91f07243b462e8952309b20eaf1e9df57e74483)

<a id="element-01a1452d-f57d-7f09-b5d9-f0eccc54ab4f"></a>

Select the roles that may view this report.

<a id="element-01a1452d-f57d-7ed1-a969-dbcd0588001b"></a>

![Creating Report: Select the roles that may view this report.](https://docs.mintsd.com/api/reader/assets/assets/images/image1097.png?v=652471ebc50cc3949a6edcfbd504eead0d8001f49f4d59b6cc3b212d1ebc4bdf)

<a id="element-01a1452d-f57e-7b53-b1e9-3a624c5c2f4a"></a>

The **Filters** section is below.

<a id="element-01a1452d-f57e-7f9a-be39-c5b02c6f7cbc"></a>

![Creating Report: The Filters section is below.](https://docs.mintsd.com/api/reader/assets/assets/images/image652.JPG?v=c2dfb83d7aba4805a3fe5922b2d5d105c4af4aebe30c503742103f70cd67a562)

<a id="element-01a1452d-f57f-7d2e-a2a4-5d432b50094b"></a>

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

<a id="element-01a1452d-f57f-7f7d-af12-95d87856fab0"></a>

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**.

<a id="element-01a1452d-f57f-7088-9f5f-69bf45edc0bf"></a>

## Filters

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

<a id="element-01a1452d-f580-73d6-9db4-6b029e0b15a9"></a>

![Creating Report: In the drop-down list, after the basic fields, there is a section with custom fields.](https://docs.mintsd.com/api/reader/assets/assets/images/image852.JPG?v=533e1e0f5bc4d72ad788c0929077f1e7d03fdccc07fc8ac60b2ac9d2ad58623f)

<a id="element-01a1452d-f580-796e-b24b-8cab81fbade1"></a>

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

<a id="element-01a1452d-f581-7847-8fe1-eda9e6c62461"></a>

![Creating Report: Hover over a custom field to see its Ticket Type and Group.](https://docs.mintsd.com/api/reader/assets/assets/images/image853.JPG?v=00d46e1871038fe34917a14d2e0b26ef7ec1991e573ef58e7b1448f7f020f874)

<a id="element-01a1452d-f581-738e-846d-39dd165265a2"></a>

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

<a id="element-01a1452d-f582-7049-92f1-734f19b439fc"></a>

![Creating Report: The same information is available after you select a custom field.](https://docs.mintsd.com/api/reader/assets/assets/images/image854.JPG?v=2e34b19297a97d977f547222695c580ae9c6367394f02280aedac4d02eb536d7)

<a id="element-01a1452d-f583-7b12-87c4-2e98e444fce7"></a>

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

<a id="element-01a1452d-f583-789e-a72e-e86d12e079b3"></a>

![Creating Report: In Export, choose the file format in ‘Export type’ and the language in ‘Default language’ to enable report downloads.](https://docs.mintsd.com/api/reader/assets/assets/images/image1291.png?v=516e5bf4bfd08f5d89147eb34b5f76e0cf6bfba924f7458eead40a78e9d1ee52)

<a id="element-01a1452d-f584-7e26-8d35-a39842c515d3"></a>

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

<a id="element-01a1452d-f584-7ae5-8842-0ba382fbf588"></a>

![Creating Report: The Report groups section below Export groups tickets or assets by your chosen criteria. You can add up to five items.](https://docs.mintsd.com/api/reader/assets/assets/images/image828.JPG?v=10a13a2bbc0e7cb0b8d008da196a46ff8cbb7d9fc2c63d7f0545e7a0d177f184)

<a id="element-01a1452d-f585-78a7-acb2-a750f60fcd95"></a>

Example of a report using **Report groups**:

<a id="element-01a1452d-f585-7ad6-8770-b6854ed2f812"></a>

![Creating Report: Example of a report using Report groups:](https://docs.mintsd.com/api/reader/assets/assets/images/image829.JPG?v=0e72dfdc0f0cecd6e877d01a63095bc18d4f85a5b912bee4d85a1a5bb4341e63)

<a id="element-01a1452d-f586-7033-98e9-3addc35bf88b"></a>

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

<a id="element-01a1452d-f586-7c9b-972e-93e937733bd1"></a>

![Creating Report: In Report recipients, select who should receive the report by email.](https://docs.mintsd.com/api/reader/assets/assets/images/image1098.png?v=258eadaec7f511afb6f3b9c4094d8f14b8af02c261342c12516dc161f19c4fdb)

<a id="element-01a1452d-f586-732c-b3c5-d988fdb1c8da"></a>

<a id="element-01a1452d-f587-7863-977f-18145f2e1d71"></a>

You can click on ![Add recipient](https://docs.mintsd.com/api/reader/assets/assets/images/image1099.png?v=36f664b74be15c4247613f1239476d2cdf9c2b4f3824eec64f931be0d8a62c97#element-01a1452d-f586-732c-b3c5-d988fdb1c8da) button and select from the list of saved recipients:

<a id="element-01a1452d-f587-7fd7-9188-11a9b417d369"></a>

![Creating Report: You can click on illustration button and select from the list of saved recipients:](https://docs.mintsd.com/api/reader/assets/assets/images/image1101.png?v=20a82de159436c3cf5049200e394ff074dea3cd8e4654f4ff7c0e2d6c4f53b8e)

<a id="element-01a1452d-f587-7993-9324-8e3794ac4224"></a>

<a id="element-01a1452d-f588-7023-ad7d-2b831a764acf"></a>

Alternatively, click ![Add custom recipient](https://docs.mintsd.com/api/reader/assets/assets/images/image1100.png?v=c8052e1789d676e1671bcd0fea08d85f039007e91a60b08c3265967ebd1082fd#element-01a1452d-f587-7993-9324-8e3794ac4224) to add an email address.

<a id="element-01a1452d-f588-729a-8f67-4b7d41382fca"></a>

![Creating Report: Alternatively, click illustration to add an email address.](https://docs.mintsd.com/api/reader/assets/assets/images/image1102.png?v=09766f349ff06c4a694e088d4fce60b237566ee5e88a3dda0e8ac950cd411409)

<a id="element-01a1452d-f589-7a55-b927-04497eac1263"></a>

<a id="element-01a1452d-f589-7671-8309-a45325957c23"></a>

## Example: a ticket report

After filling in all the fields, click the ![Save](https://docs.mintsd.com/api/reader/assets/assets/images/image8.png?v=c6dfcae62b1da5a56376cb98f40e0a593d8d731e458977d27180f6380454b49d#element-01a1452d-f589-7a55-b927-04497eac1263) button. The report configuration is now ready for generating a new report.

<a id="element-01a1452d-f589-76d6-b796-972fd2989d94"></a>

The following example creates a report for all tickets:

<a id="element-01a1452d-f58b-770f-82d2-4c5c1af244d0"></a>

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

<a id="element-01a1452d-f58b-7a50-9127-dadd41bb6854"></a>

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

<a id="element-01a1452d-f58b-7f63-92de-c0d85719c5e7"></a>

![Creating Report: Select the report type in ‘Please select the type of report you want’.](https://docs.mintsd.com/api/reader/assets/assets/images/image214.png?v=c8f91d9cb9335042d1118ea36857040c1609a8744cd4c78a97d92337f30d3ca4)

<a id="element-01a1452d-f58c-7603-95e2-c2058cecae51"></a>

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.

<a id="element-01a1452d-f58c-7f34-935c-32c6200c8409"></a>

![Creating Report: 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.](https://docs.mintsd.com/api/reader/assets/assets/images/image653.JPG?v=33e1c30e4c03f29b6f7cb23eb474766caa65c36f62bf0b757dd721c9be070bad)

<a id="element-01a1452d-f58d-707d-b2f0-aa3a6b34937f"></a>

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

<a id="element-01a1452d-f58d-70a5-860e-d99510a2666f"></a>

![Creating Report: Click ‘X’ next to a field to remove it. In this example, remove ‘Ticket type’.](https://docs.mintsd.com/api/reader/assets/assets/images/image215.png?v=e9134a2109910f0b1e645532c46df826bf3d3650798a15c35fbb53ebe1704829)

<a id="element-01a1452d-f58e-718c-ae0c-caf06509ab9a"></a>

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

<a id="element-01a1452d-f58e-73f3-896f-b7717d410da2"></a>

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

<a id="element-01a1452d-f58f-7867-9a98-2a091715a4c5"></a>

![Creating Report: To add a new field click on the field located below.](https://docs.mintsd.com/api/reader/assets/assets/images/image654.png?v=f0fa3a1b2b24e086881839799aa835f1633b91e8c1a0a7af9009538c42da4f05)

<a id="element-01a1452d-f58f-71b8-b65a-bfccdcb69f94"></a>

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

<a id="element-01a1452d-f58f-74a8-a940-c72e00fcd03d"></a>

![Creating Report: Select ‘Company user’ from the list of available fields. You can add further fields while unselected items remain in the list.](https://docs.mintsd.com/api/reader/assets/assets/images/image655.png?v=4cc036fbae2f149481fb93800455ef0a5551f5716b9ff4985a4ad7dc6203ba37)

<a id="element-01a1452d-f590-7d1d-a12d-45e65779db61"></a>

The selected field appears in ‘Fields’.

<a id="element-01a1452d-f590-763b-b794-1c7e12c831b8"></a>

![Creating Report: The selected field appears in ‘Fields’.](https://docs.mintsd.com/api/reader/assets/assets/images/image218.png?v=ca510807de65a8d52657a5577e3165cfd417e692737423a1c986808f495b0ed4)

<a id="element-01a1452d-f591-7ff5-be20-eef50a632fac"></a>

<a id="element-01a1452d-f591-7cb3-8ff3-8ad52e9d9211"></a>

To add a company user filter, click ![Add filter](https://docs.mintsd.com/api/reader/assets/assets/images/image219.png?v=ce1690590f7664b910056e8d99bad0399c3fd122794aa0cb6390f28a6feb789c#element-01a1452d-f591-7ff5-be20-eef50a632fac) below the selected filters.

<a id="element-01a1452d-f591-7bf2-9ff8-d37a014d9cde"></a>

![Creating Report: To add a company user filter, click illustration below the selected filters.](https://docs.mintsd.com/api/reader/assets/assets/images/image220.png?v=84d7a691ca75d8c45e4a1da09d8ae1413ebb8d01da74ca3a0f9a4afc3084a6ef)

<a id="element-01a1452d-f592-7108-8415-b7b496dcc0ad"></a>

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

<a id="element-01a1452d-f592-78aa-9cfb-be43b9747824"></a>

![Creating Report: From the newly created ‘Filter fields’ list select ‘Company user’.](https://docs.mintsd.com/api/reader/assets/assets/images/image656.png?v=64e82462bf223131a61a965ad020f35b7ef020c587db85d870072103c224ddf4)

<a id="element-01a1452d-f593-7fa7-968e-ff8669b5f729"></a>

<a id="element-01a1452d-f593-7b59-85d6-30171546b67d"></a>

<a id="element-01a1452d-f594-7c10-a58f-9395d28d84e4"></a>

Click ![Add](https://docs.mintsd.com/api/reader/assets/assets/images/image3.png?v=50654a0321a77a3b2271140f1b6a5080d18fbef92f3639b9b83ad57f0fd5735d#element-01a1452d-f593-7fa7-968e-ff8669b5f729) to add the filter, or ![Delete](https://docs.mintsd.com/api/reader/assets/assets/images/image223.png?v=df3d43dd338727ffc9cd77e2d0beccc39f39a888c90ff503872c9a0363100ddf#element-01a1452d-f593-7b59-85d6-30171546b67d) to cancel.

<a id="element-01a1452d-f594-7ebf-8a08-ae5b7e525840"></a>

![Creating Report: Click illustration to add the filter, or illustration to cancel.](https://docs.mintsd.com/api/reader/assets/assets/images/image224.JPG?v=55f05a31e202ef9a1f3682bdbdecd5456f84898e1b38e442a9a7634a0c84d924)

<a id="element-01a1452d-f595-7c9d-9989-d565a83f2eab"></a>

The filter appears in the list.

<a id="element-01a1452d-f595-74cb-a20d-458c6b984ea5"></a>

![Creating Report: The filter appears in the list.](https://docs.mintsd.com/api/reader/assets/assets/images/image657.JPG?v=0e728e9153e5aadd1848b8a2a3139ae382e33fcd0ca38fbeb378306827afd07d)

<a id="element-01a1452d-f596-7639-aa8b-9ca8c921f5bc"></a>

Set the filters to find tickets:

<a id="element-01a1452d-f597-7a9d-9c97-3c1daa0eb850"></a>

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

<a id="element-01a1452d-f598-76e6-b4e5-e9617eea8277"></a>

Select the filter values shown below.

<a id="element-01a1452d-f598-7b04-8557-77eaf2cb84ad"></a>

![Creating Report: Select the filter values shown below.](https://docs.mintsd.com/api/reader/assets/assets/images/image658.png?v=47b5bf1f7ceaa49feb9a415fafde2a180b9635d9307ed79c45b040af57872c5e)

<a id="element-01a1452d-f598-7adf-b8af-6971db39b87f"></a>

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

<a id="element-01a1452d-f599-7ead-b354-20dd8e48f7a7"></a>

![Creating Report: To remove a selected value, click ‘X’ next to its name. The ‘X’ on the right of a filter clears all its selected values.](https://docs.mintsd.com/api/reader/assets/assets/images/image659.JPG?v=826b5b9edf3de6c1aa3d36362f5a3022de4f0433be98b456666acfae18ac8694)

<a id="element-01a1452d-f599-7a0c-9d01-b3435ae19126"></a>

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

<a id="element-01a1452d-f59a-7736-bcc0-73190d17e00a"></a>

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

<a id="element-01a1452d-f59a-7c3b-ba77-c9d11904e41e"></a>

![Creating Report: The report cannot yet be saved with ‘Save’: unused filters are outlined in red.](https://docs.mintsd.com/api/reader/assets/assets/images/image660.png?v=36b6f9db958db3327d28e130bfab2069b0322328ac241ff0760cdd92023a511d)

<a id="element-01a1452d-f59a-7cbb-aea8-5da09636d19c"></a>

<a id="element-01a1452d-f59b-7ba1-a51e-c03a01ee9d8c"></a>

Delete those filters you don’t want to use by clicking ![Delete](https://docs.mintsd.com/api/reader/assets/assets/images/image228.png?v=b49c174f13ec30cdd023f322f43c60d2f2e16a16d3f207ccbfa119b0906a0fe2#element-01a1452d-f59a-7cbb-aea8-5da09636d19c) button
next to each of them.

<a id="element-01a1452d-f59b-7377-ba86-19ad740b9e7c"></a>

![Creating Report: Delete those filters you don’t want to use by clicking illustration button next to each of them.](https://docs.mintsd.com/api/reader/assets/assets/images/image661.png?v=e2b8e5dd4bee1da3eaf5d75f2fb9a8acf527e6f015331007d71dd801c36d5c34)

<a id="element-01a1452d-f59c-7aa5-999a-745733ef4a57"></a>

<a id="element-01a1452d-f59c-7eab-9fa6-25f3b096d70f"></a>

Click ![Save](https://docs.mintsd.com/api/reader/assets/assets/images/image8.png?v=c6dfcae62b1da5a56376cb98f40e0a593d8d731e458977d27180f6380454b49d#element-01a1452d-f59c-7aa5-999a-745733ef4a57) button to create the report. Once you do that you will
see a new position on the list in the ‘Report definitions’ view.

<a id="element-01a1452d-f59c-774c-9577-b7c5545ad4d5"></a>

![Creating Report: Click illustration button to create the report. Once you do that you will see a new position on the list in the ‘Report definitions’ view.](https://docs.mintsd.com/api/reader/assets/assets/images/image231.png?v=8175617ab5a290ccd0e5aec891bb54d138383ebdf8632f7e5b3da0f60494754c)

<a id="element-01a1452d-f59d-7700-98cd-cc60f6720618"></a>

<a id="element-01a1452d-f59d-7827-b5e9-e1113a2f2751"></a>

To change a saved report, click ![Edit](https://docs.mintsd.com/api/reader/assets/assets/images/image89.png?v=702adcf46ea452d46f158b0c91e923f5b40ae6f37d95ca5764e20654a2855c4c#element-01a1452d-f59d-7700-98cd-cc60f6720618) to open ‘Edit report’.

<a id="element-01a1452d-f59d-7dfe-a93f-91b227cf52f2"></a>

<a id="element-01a1452d-f59e-7523-8454-40f2396e84e0"></a>

To delete the report, click ![Delete](https://docs.mintsd.com/api/reader/assets/assets/images/image202.png?v=1ae492635a6fc6619d5b242c62eff118e37d8d48440153360fc4ec4913f5ed3a#element-01a1452d-f59d-7dfe-a93f-91b227cf52f2) and confirm with ‘Yes’.

<a id="element-01a1452d-f59e-75b3-975b-ab1402d9c0ab"></a>

![Creating Report: To delete the report, click illustration and confirm with ‘Yes’.](https://docs.mintsd.com/api/reader/assets/assets/images/image238.png?v=211a7a6784888016ca04bb2738264d447feeb9912d19de8c5f008b9250c8b9e3)

<a id="element-01a1452d-f59f-7798-a284-b74afbb2304c"></a>

## SQL Reports

<a id="element-01a1452d-f59f-7986-b102-706b59615012"></a>

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.

<a id="element-01a1452d-f59f-7491-abdf-fddb834fc7c4"></a>

![Creating Report: 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.](https://docs.mintsd.com/api/reader/assets/assets/images/image1182.png?v=8c02de7af0532e2d27591686f03f2568d2ec33196cd9b3ed26d459c40b6a1e39)

<a id="element-01a1452d-f5a0-76ac-a6e9-88024704142f"></a>

![Creating Report: 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.](https://docs.mintsd.com/api/reader/assets/assets/images/image1183.png?v=02ef6a075fe0d36a5adeafb11369307f836019695a6a5b3d4b4221a9b7a2fe81)

