Extract details of a Sprint Report

[Juanita De Jong]

How do I export a Sprint Report to excel with the indicators as displayed on the Sprint Report: Completed / Removed during sprint / Injected after sprint started, the movement in story points, etc....

Or are those Jira fields that I can add to my query that will display those indicators ?

[Aron Gombas _Midori_ · Accepted solution]

You cannot get that date directly with an end-user feature.

We implemented PDF export for these in our PDF exporter app, and it was very complicated to get these even programmatically. If the PDF is a viable alternative for you, I suggest you check out Better PDF Exporter.

Learn more here

[Juanita De Jong]

Thank you very much Aron

[Jack Brickey · Accepted solution]

I don't believe there is a way to export a single CSV that would cover all outcome conditions (Completed, Removed, Incomplete, etc). You could do them individually either thru JQL or simply go to the specific sprint report and click on the "View in issue navigator" link then export. Then you could combine into one file w/ a newly defined 'outcome' field.

[Juanita De Jong]

The test I'm doing now has 1 item in the "Issues Removed From Sprint" section of 1 sprint. When I click on 'View in Issue navigator" and add the column "Outcome' to the view, it is blank

[Jack Brickey]

"outcome" isn't a Jira field. i was simply saying you could manually create this after export. in otherwords:

• export 1 = completed in sprint so add "completed" in an 'outcome' column or whatever you want to call it
• export 2 = removed from sprint add "removed" in the 'outcome' column
• export 3 = incomplete....

[Juanita De Jong]

It just happened that there is a field called 'outcome'.... so how does Jira keep that info (indicators) to use in the Sprint report?

[Jack Brickey]

i guess that is a custom field on your side. nice coincidence. :-)

I'm not sure how Jira keeps/determines this info TBH. You might search the Community to see if you get any clues or maybe the documentation.