Nesting group headers in tables

  • 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

  • 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