How to create a report displaying all fields on Jira?

[Angel Casas]

Hello, I would like to create a report displaying opened vs unresolved issues report containing all the fields and be able to export it to Excel.

[Earl McCutcheon]

Hi Angel,

I believe your best approach is to create two filters one for the open and one for resolved issues with something like the following:

• project in (a,b,c) AND resolution is EMPTY ORDER BY created

• project in (a,b,c) AND resolution is not EMPTY ORDER BY created

Then Export the data via "CSV (all fields)" option in the issue navigator, to use for your report in Excel.

Also if you are looking for a native Excel formatted file there is not a local option any more as discussed in JRASERVER-61891 but there are many Excel focused add-ons that can be used to accomplish this viewable here.

Regards,
Earl