DynamicReport for JIRA

• 

  Write a report template in Microsoft Excel

• 

  Upload your template to your JIRA instance

• 

  Create the report from the JIRA search page

Inspiration

At our development site, we use Jxls a lot to create Excel format reports. Jxls allows the user to create template files with practically unlimited formatting and to populate these files with data from various sources. Excel also is the most important file format for our main customers. On the other hands, the exporting features of JIRA are limited to various HTML formats without the chance to influence the template. So the idea was to combine the mighty search features of JIRA and the templating functionality of Jxls.

What it does

Fill Jxls style templates with data from JIRA searches

Challenges I ran into

The API for extending the search functionality is rather limited.

Accomplishments that I'm proud of

Dynamically extend the "Export" dropdown on the search page, referencing uploaded templates (which was probably not planned by its developers)

What I learned

A lot about JIRA internals

What's next for DynamicReport for JIRA

• Integrate with other search features in JIRA, e.g. on the project level
• Use 7.0 API, which makes things a bit easier (for now, I don't want to lock out JIRA 6 users)
• Maybe a cloud version

Built With

• java
• jxls