Showing posts with label subsequent. Show all posts
Showing posts with label subsequent. Show all posts

Monday, March 19, 2012

Group Heading text different on repeated headers

Is there any way to have the data displayed in a group header different on the first occurrence of the header from subsequent occurrences within that same group?

I have the Repeat Header option checked, so the header appears on every page. I want the pages where it is a continuation (has been repeated because the option is on) to look different, e.g., the group's name cell should be "<name> (cont.)", where on the first page it appears it should be just "<name>". I can use an expression in a cell in the header, but I don't see any convenient function or other way to detect whether this is the first, or a subsequent, instance of the header.

I thought of using the RowNumber function, scoped to the header grouping, but this seems to return the row number of the bottom-most (last) detail row of the group - that is, the number of rows in the group - so that doesn't seem to help.

Have you found any solution to the issue in your post? I would like to do the same on a grouped table report and cannot seem to find the key.

Group Heading text different on repeated headers

Is there any way to have the data displayed in a group header different on the first occurrence of the header from subsequent occurrences within that same group?

I have the Repeat Header option checked, so the header appears on every page. I want the pages where it is a continuation (has been repeated because the option is on) to look different, e.g., the group's name cell should be "<name> (cont.)", where on the first page it appears it should be just "<name>". I can use an expression in a cell in the header, but I don't see any convenient function or other way to detect whether this is the first, or a subsequent, instance of the header.

I thought of using the RowNumber function, scoped to the header grouping, but this seems to return the row number of the bottom-most (last) detail row of the group - that is, the number of rows in the group - so that doesn't seem to help.

Have you found any solution to the issue in your post? I would like to do the same on a grouped table report and cannot seem to find the key.