Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Report Organized By Stories & Sub-tasks

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). 

Structure.PNG

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.

Report.PNG

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.

 

 

4 answers

Hi Mike,

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.

Screen Shot 2021-12-22 at 4.08.12 PM.png

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!

Phil Heijkoop

ALM Works

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.

Hi Mike,

Happy new year, I have three ways to do this even.

  1. If the Web Links are referenced in a field, you can just add the column, if it's a web link type field it will automatically be represented as such. This exact same mechanism works if it's a link that Jira automatically recognizes as a clickable link (think other Jira tickets, Confluence pages, attachments, etc)
  2. If it's just text, you can "convert" it to a html link by representing it in our super powerful formula column (you just fill in the field as the formula definition), then set the column to represented as wiki markup and it's automatically a clickable link.
  3. We can get even fancier with our formulas and define link text and where it points to, similar to 2 but much more customizable.

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.

Best,

Phil

@Philip Heijkoop _ALM Works_ Can we arrange for an interactive demo of Structure? 

Hi, @Mike Triplett. I can answer this: Yes.

Drop us a note at solutions@almworks.com and reference this thread. :)

-dave

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:
issue_epic_hierachy.jpg

 

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

 

best,
Gerda // support@eazyBI.com

Gerda - Thank you for the reply. I have been able to get eazyBI enabled in one of our Jira instances as of this time, and will do an eval with a prototype project.

Like # people like this

Hi @Mike Triplett ,

Glad to hear that you are trying out the eazyBI!

If you have any questions about the setup you are interested in, please don't hesitate to write directly to us and we will be happy to help you: support@eazyBI.com

 

best,
Gerda

Hi @Mike Triplett

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:

hierarchy.gif

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!

Best,

Hannes

Thanks Hannes, looks interesting. Do you have an example that displays Web Links that have been added to sub-tasks? What does it look like when exported to PDF?

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.

Best,

Hannes

@Mike Triplett

just to give you some impressions, here's how this works with a "URL" custom field.

First, this is the field in JXL:

url-in-jxl.png 

Second, this is how it looks in JXL's export to Google Sheets:

url-in-google-sheets.png

 

Finally, this is looks in a PDF exported from Google Sheets:

url-in-pdf-export.png

(The link remains clickable throughout all steps, of course.)

Best,

Hannes

0 votes
Rahul_RVS_Support Marketplace Partner Dec 22, 2021

Hi @Mike Triplett 

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.

Agile Tools : Epic Tree, Links Tree, Time in Status & Worklogs

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

Links Hierarchy.png

Epic Hierarchy.png

 

Time in Status.png

Thanks for responding. Time reporting is not a requirement. As I mentioned, Web Links are a requirement - do you have an example that shows displaying Web Links that are added to sub-tasks?

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

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

Events near you