JIRA Cloud: Can PDF reports be generated based on a template, including charts and gadgets?

[Ignacio Pulgar]

I would like to be able to automatically generate a PDF based on a template, with information from issues matching several JQLs as well as some charts and contents from some gadgets.

An ideal solution would allow to build reports much like iReport can do against a queryable database.

Are there any solutions to achive this on Cloud?
(ie: addons, workaround in Confluence, external app + external database + API calls...)

[Aron Gombas _Midori_ · Accepted solution]

Better PDF Exporter for Jira Cloud supports most of those that you mentioned:

1. report templates
2. executing JQL queries
3. drawing charts (and any sort of graphics)

You will be able to build really powerful reports using this toolset, like this example:

[Nic Brough -Adaptavist- · Accepted solution]

I'm not aware of any add-ons that could do anything like that (and you won't get access to the database).  You would probably have to write something that can scrape the data you need over REST and reformat it.

[Ignacio Pulgar]

Thanks, Nic! That's what I'm afraid of. I've stumbled upon Jirassimo addon, but it seems not to be a solution for what I need.

[Ignacio Pulgar]

+1'ed your response, but will leave this answer open for the moment, just in case anyone knows of a solution.

[Ignacio Pulgar]

The solution I'm going to bet for is using a Confluence global template.

[Ignacio Pulgar]

I went too fast, assuming that Confluence variables could be used within macros. As that doesn't seem to be the case, I will accept your answer as currently being the most accurate one.

[Midori]

PDF View Plugin offers all the features you mentioned (a probably a lot more like supporting dashboards, Scrum boards, automations, etc.) for hosted JIRA instances.

If you are interested in the cloud version of this, vote to the public feature request, add a comment about your needs / use case and follow the updates there.