December 6, 2010 at 1:36 pm
Hi
I'm working on a report that has a table consisting of three groups:
Group 1
Group 2
Detail
Only 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 1
Group 2 Header 1
Group 2 Row 1
Detail Header 1
Detail Row 1,1
Detail Row 1,2
Detail Row 1,3
Group 1 Row 2
Group 2 Header 2
Group 2 Row 1
Detail Header 2
Detail Row 2,1
Detail Row 2,2
Detail Row 2,3
Any 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
December 6, 2010 at 3:12 pm
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 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply