Reporting services and JIRA cloud

[Jozef Vodny]

hello,

we already run reporting services (our custom reporting on top of JIRA database) presently on JIRA Selfmanaged  version (on our HW). My question is if we could use this reporing services also on JIRA Cloud version.

thanks 

[Mehmet A _Bloompeak_ · Accepted solution]

Hi @Jozef Vodny ,

The alternative way of accessing data on Jira cloud is the Jira Rest APIs. You can either pull the whole issue data via rest api in a scheduled manner(e.g daily) or you can define Jira webhooks which will push issue changes into your system.

Alternatively, you can search for reporting apps in the marketplace. One useful metric can be lead/cycle/resolution time of issues. For this exact reporting need, we developed Status Time app. There is also free but limited version of it, Status Time free.

Once you enter your working calendar into the app, it takes your working schedule into account too. That is, "In Progress" time of an issue opened on Friday at 5 PM and closed on Monday at 9 AM, will be a few hours rather than 3 days. It has various other reports like assignee time, status entry dates, average/sum reports(eg. average in progress time per project).

Here is the online demo link, you can see it in action and try. Hope it helps.

[Jozef Vodny]

hi...thanks for hints.... just to clarify our goal.... we would like to use jira for project planning and task management and work management ....but for reporitng we need except work (actual, planned, ...) reports also financial reports based on each project....for this purpose we had reports done thought Reporting services which work fine....but now we have to decide to move to Cloud version of JIRA and if I understand well theres no posibilities to keep financial reporting based on Reporting services...

could you advice some solution for this purpose  please? (idealy cheap and easy implementation :) )

[Nic Brough -Adaptavist- · Accepted solution]

No.  You have no access to the database in Cloud. 

You will have to throw away your database reporting and build your reporting properly

(database access to Jira is the worst possible way to try to report on it, and in 16 years, I've yet to find a place doing it that didn't have dozens of reports that were simply wrong)

[Jozef Vodny]

thanks for advice