How can I generate a Jira report that includes the release version and its associated issues?

[Roger Alexis Mosquera Montaño]

Hello

I need to generate a report from JIRA that shows a list of issues associated with a release version, including the current status of the release, the release description, and various fields of the issues such as key, summary, status, etc....

It is important that this report can be exported to an Excel file.

How can I create a report with these characteristics?

Thanks

[Kalyan Sattaluri]

Hello @Roger Alexis Mosquera Montaño 

Unfortunately, there is no such report OOTB. You have to either use third party add-ons or integrate with Jira Rest APIs in Tableau / Power BI or Excel so you can customize your report.

[Roger Alexis Mosquera Montaño]

Hello @Kalyan Sattaluri 

Thanks for the answer.

[Aron Gombas _Midori_]

You can do this by

First execute a query like this in the Issue Navigator:

fixVersion = "1.2.3"

Then select the columns you are interested in, and export the data set with Better Excel Exporter using the "Current fields" export type.

It will produce a standard Excel spreadsheet containing an issue list like this:

If you need the release meta-information (version name, description, etc.) then create a custom Excel export template for that. It should be rather straightforward, but please feel free to ask.

(Discl. it is a paid and supported app developed by our team. Free for 10 users!)

[Roger Alexis Mosquera Montaño]

Hi @Aron Gombas _Midori_ 

Thanks for the answer.

I really need a report that can include multiple fix versions with their associated issues without having to specify a particular fix version.

Thank you very much.

[Hannes Obweger - JXL for Jira]

Hi @Roger Alexis Mosquera Montaño

you may already be aware of this, but you can receive the issues of a version using Jira's standard issue search, with a JQL clause like

fixVersion = <your fix version>

You should also be able to export these issues to Excel. This would not include the fix version name and details, but maybe that's something you could add manually?

Alternatively, if you're open to solutions from the Atlassian Marketplace, you'll likely find more optimised options there. As an example, you may want to have a look at the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

With these, you can build a report like e.g. this in just a couple of clicks:

This is really just one of a virtually endless number of possible views and reports - you can also view, group by, and sum up any other field(s). Of course, your sheet can also be exported to Excel in just one click.

Any questions just let me know,

Best,

Hannes

[Roger Alexis Mosquera Montaño]

Hi @Hannes Obweger - JXL for Jira

Thanks for the answer.

I really need a report that can include multiple fix versions with their associated issues without having to specify a particular fix version.

Thank you very much.