Nesting group headers in tables
-
Hi
I'm working on a report that has a table consisting of three groups:
Group 1Group 2DetailOnly the outermost group is visible when the report is rendered. Group 2 is toggled by a textbox in group 1. The "detail" group is under group 2 and is also invisible initially, and toggled by a textbox in group 2. The "detail" group and group two have two rows each. I want the first row to be a group header and to only appear once at the top. I can get this effect for the "detail" group using the following formula in the visibility > hidden property of the top row of the detail group:
=iif(RowNumber("table1_Group_2")= 1, False,True)
...but I can't work out how to get the same effect for group 2.
It should look like this:
Group 1 Row 1Group 2 Header 1Group 2 Row 1Detail Header 1Detail Row 1,1Detail Row 1,2Detail Row 1,3Group 1 Row 2Group 2 Header 2Group 2 Row 1Detail Header 2Detail Row 2,1Detail Row 2,2Detail Row 2,3Any ideas gratefully received.
Regards
GPO
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
-
I worked it out (and it's kinda obvious now that I look at it). The header for the child groups is actually a row in parent group.
Cheers
GPO
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply