How to run a report or export the tickets information to customer

[Michael Woong]

Some of my customers would like us to provide monthly support tickets report, which including status (i.e. in progress, resolved...etct).

I managed to created a queue but no export function available.

Please help.

[Walter Buggenhout · Accepted solution]

Hi @Michael Woong,

Your queue is based on a filter that you created. If you apply that same filter in Filter > Advanced issue search, you do have the ability to export the issues from there.

You can even save the filter there, so it becomes reusable for monthly exports.

Hope this helps! 

[Michael Woong]

Can you export to csv or pdf.

[Alex Koxaras _Relational_]

Hi @Michael Woong 

Default export file formats are CSV, HTML, XLM, Excel, Google Sheets, Word, RSS.

[Levente Szabo _Midori_ · Accepted solution]

@Michael Woong 

If instead of just exporting issues to Excel you would like to use templates to create useful Excel reports like the one below, one option you can also try is Better Excel Exporter Cloud.

You can not only export a mere list of Jira Service Management ticket, but export meta data (history, internal/public comments, etc) or create pivot tables and charts to communicate more insightful detail to your customers.

You can browse more export and Excel report examples to learn what can be achieved with Better Excel Exporter Cloud!

(Please note that Better Excel Exporter is a paid and supported app and I'm part of the team developing it.)