How to create dynamical multilevel groups in Jasper?

[corina01]

In the Name column I have a dynamic hierarchy, where I don't know how many levels may be. In my database, I have values only for leaf elements (in this case the Subchild elements). I need to calculate the sum for parent elements (go upper in the hierarchy). For example, if we look at Type1 column, Subchild1 + Subchild2 = Child1

I tried with groups, but they work only if I know the exact hierarchy level number. List and tables can work with hierarchy, but I dind't find a way for them to calculate the sum up in the hierarchy.

Does anybody know how to do it? Or at least if it's possible.

Edited December 14, 2023 by corina01

[Akshay Khedkar]

Hello,

This could be an Enhancement. please raise an Enhancement request.  I'm pleased to let you know about an improved method  to make it easier for TIBCO Jaspersoft users to report enhancement ideas, track the status of those enhancements, and vote for ideas/enhancements that you consider to be most useful. This will be done by using the new Jaspersoft Ideas Portal https://jaspersoftideas.tibco.com/ 

[corina01]

@akshay.khedkar Thank you for the suggestion. I posted a new idea and would really appreciate your vote.

https://jaspersoftideas.tibco.com/ideas/JSPR-I-4664