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