JQL for Multiple Sprint Reports

Question

I have about 20 Projects that close sprints every other week (say Wednesday) Currently for reporting purposes I pull the sprint report from the previous sprint (the one just closed) and the current sprint (the one just opened) I remove any items that were removed from the sprint and dump the data into excel.  I do this manually for each project currently. Is there a JQL filter that I can set that will pull all the data at once, or a way to automatically send me the reports when new sprints are opened.

Ashleigh Wansbrough · Answer

I am already evaluating Better Excel in combination with Automation for Jira, but I still need the filter. The out of the box templates are not what we are looking for. Thanks for the suggestion.

Mohamed Adel · Answer

@Ashleigh Wansbrough

You can try this add-on Better Excel Plugin for Jira (XLSX/XLS) it has similar functionality you are asking for