I have been searching for the functionality or an add-on that will produce a report with the structure depicted in the below image. We have several epics that have stories and sub-tasks (standard Jira structure shown in first image).
From those epics, we need to produce a report that has the structure shown below, that lists each story with the story's sub-tasks listed below their parent. Ordering is not a problem, the issue that needs to be solved is grouping the sub-tasks with their parent. We need to specify which fields are included in the report, such as summary and status but we also need to include web links if at all possible.
Has anyone made a report like this? If so, how did you do it? What add-on did you use?
Any help would be appreciated. Thank you.
That sounds exactly like what Structure for Jira is designed to accomplish (full disclosure, I work for the company that makes Structure). You can define which epics to put at the top level and then build out a tree-type hierarchy of the stories below them and then the sub-tasks below their respective stories below that.
You can also add in the rows for each field you'd like to see (it's very Excel-like, so should be fairly familiar), you can also roll up any of that field information if it's numerical. I added a quick screenshot to give you an idea of how it works, or feel free to play around in our demo instance.
Happy to elaborate more if you'd like, happy holidays!
Than you for responding Phil. Structure is on our short-list for evaluation. Do you have an example report that includes Web Links that have been added to sub-tasks? Also, time reporting is not in scope for this project so time spent specifically needs to be excluded from the report. Ultimately the report will need to be in PDF format so it can be eSigned.
Happy new year, I have three ways to do this even.
If you don't like or need the time aggregation, you can add and remove columns as needed. Save any set of columns you like for quick recall later.
Export to PDF comes out of the box, click the export button in the top right.
Hi @Mike Triplett ,
eazyBI for Jira offers a default Epic hierarchy, which includes the hierarchy of Epic->Standart issue types (story, feature, etc.)->Sub-task issues types.
Here is an example of how the hierarchy looks in eazyBI and what type of report you can create:
And if in addition to that you would like to see what web links are linked to issues, you can check those answers from the eazyBI Community on a similar question:
- How to import 'web links': https://community.eazybi.com/t/issue-with-web-link/3967
- How to import confluence links: https://community.eazybi.com/t/import-wiki-page-link-into-eazybi/4631/2
Gerda // support@eazyBI.com
also have a look at JXL for Jira. It's a full-fledged table/spreadsheet view for your issues that produces the view that you're looking for with one click; this is how it looks in action:
Among many other things, you can view and inline-edit any field, change issues in bulk via copy/paste, filter and sort issues quickly (just like in Excel/Google Sheets), configure other hierarchy structures, export to XSLX or CSV, etc. etc. You also notice that JXL is extremely fast, even with very large amounts of issues.
Find more information here: https://jxl.app.
(Disclaimer: I work on JXL :))
Please don't hesitate to reach out for questions or support!
Hi @Mike Triplett,
Happy 2022! :)
JXL can show any field (standard Jira field or custom field), so in whatever way you're storing your web links, JXL should show them just fine. If you give me some context on how you're storing these web links, I can put together a quick video!
For the export to PDF, JXL doesn't currently export to PDF directly, but has a very nice XSLX (i.e., Excel or Google Sheets) export. So you'd export to XSLX first, open in Excel or Google Sheets, and export as PDF from there.
just to give you some impressions, here's how this works with a "URL" custom field.
First, this is the field in JXL:
Second, this is how it looks in JXL's export to Google Sheets:
Finally, this is looks in a PDF exported from Google Sheets:
(The link remains clickable throughout all steps, of course.)
We have built an add-on for this exact need. There are multiple other easy to use reports in the app thru which you can track time spent by your resources, time in each status and lot more.
The app provides the following features.
1) Epic Hierarchy :- View/Manage roll up of time estimates for standard Jira hierarchy. Epic -> User Story -> Subtask
2) Links/Portfolio/Advanced Roadmaps Hierarchy :- View/Manage roll up of time estimates for hierarchy (up to 10 levels), based on your Portfolio/Advanced Roadmaps/Issue Links parent child relationship.
3) Time in Status :- More than 7 types of Time in Status reports to track your issues.
4) Worklogs Report :- Track time spent by resources with multiple filters / category / grouping features
5) Timesheet :- View/Enter your time spent for multiple days
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events