Joined: 18 Aug 2021
Online Status: Offline
Posts: 12
Topic: Group header tree structure Posted: 17 Feb 2022 at 3:15am
Hi Team,
I have three groups, A, B and C and I am trying to create tree structure of group header like A is parent and B and C are childs of it meaning B and c are grouped bade on fields of A . I want to display A-->B-->C in this manner but not able to do that . Please any one can help?
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 17 Feb 2022 at 11:58am
the structure you are drawing a-->b-->c implies that c is child of b, and b is a child of a.
I don't know if it work as groups tend to cascade, what I would try is to create 2 formulas. 1 formula would be a.field = b.field and the other formula would be a.field2 = c.field2.
I am not sure if it will work...I am actually leaning towards it not working, and it is what I would try...
Oh, here is another idea. It is not a good solution as I try to avoid subreports, and create groups a and b, and then have a subreport for group c. Display it after group b, I would create a second section for Group b, and drop the subreport there. Associate the parameter between the subreport and the main report based on group a values.
Joined: 18 Aug 2021
Online Status: Offline
Posts: 12
Posted: 17 Feb 2022 at 4:33pm
Hello,
The structure I am drawing is b is child of a and c is also the child of a, and b and c had same field which is equal to field of a . Also I cannot use subreport because this structure I need is already inside subreport only and we cannot use subreport inside subreport. Also how we use formula to create such structure as u mentioned is not clear to me. Please help to clarify and achieve the same .
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 18 Feb 2022 at 6:31am
Correct, subreports only go down 1 level.
Since b and c link to the same field in A, why not just write the report with a section for B and then a section below for C information.
B and C are in the same Grouping of A.
The formula is false path given that both B and C tie to the same field in A.
The report I am envisioning would look something like this:
Group1a A - all the A information
Group1b B - Since B is tied to A, put its information in its own section
Group1c C - Same for C, tied to A in the same way
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
