JIRA reports

[rakhi]

We are trying to build our custom reports and trying to figure out the database. It does not have any replationships.

Has anyone build any reports before using the JIRA database and how? Did you build any logical layer?

[Raimonds Simanovskis · Accepted solution]

Instead of building custom reporting system from scratch you can take a look on eazyBI reporting application with JIRA integration. It will perform regular JIRA data import and will create couple pre-defined sample reports as well as you will be able to easily create new custom reports using both JIRA standard fields as well as selected custom fields. You can create reports, charts and dashboards in easy drag-and-drop style.

[Nic Brough -Adaptavist-]

Yes, several times, but always on a copy of the data (replicated copy of the database etc). I've always referred to http://confluence.atlassian.com/display/JIRA/Database+Schema to do it.

[rakhi]

Thanks Nic we will defiantely be using copy of the data to build the reports. We are lookign for Time in between statues liek we have in transition history and also how much time took from Create to Close. Also some avaerage age charts on some Custom date fields? how would you recommend doing them? Do we have any logical layer build or any data dictionary?

[Audrey Gil]

What did you use to build the reports?

[Pablo Beltran]

The SQL for JIRA add-on simplifies the JIRA database model so it is pretty easy for user creating SQL reports for JIRA.

SQL for JIRA also brings other major benefits: it shows data according to each logged in JIRA user's permissions, data coherence, etc.  

And if you want to make nice, flexible and powerful html reports embedded in JIRA Dashboards to show SQL data, then you might want also to have a look at Birt Reports for JIRA, a complementary add-on.

WhereasSQL for JIRA resolves most the JIRA reporting issues at data level, Birt Reports brings the required flexibility and extra required power at the front end level.

[mwarton]

Instead of detailed development work using the database schema, you could use a plugin like Intelligent Reports. It lets you design your report output format in Microsoft Word, and fill it in (tables, charts and all) with simple point and click rules to get whichever fields on issues, projects, versions, components, users, etc you want. All with no programming or API to learn.

[Gregory Kneller]

Alternative way for reporting is to use Confluence with SQL plugin, that assess JIRA database directly and pick any data out of it into confluence pages.