Displaying different GroupHeader for following pages

Posted by: dbelley on 23 October 2019, 4:37 am EST

    • Post Options:
    • Link

    Posted 23 October 2019, 4:37 am EST

    Hello.

    I have been struggling for hours now and decided to ask the question here.

    I have a report with a GroupHeader1 set to RepeatStyle “None” so it only appears once for each groups.

    Now my client is asking to have the GroupHeader1 shown on all pages, but with less informations on following page.

    My GroupHeader1 shows 8 different fields (datafield) one under the other. It has to continue to show all the information the first time the Header is displayed for a group but for the other pages I have to show only the top 3 fields.

    So for each groups :

    First appearance of Header : Show all the GroupHeader1

    Page 2 and following : Show less information in the Group Header

    I tried all kinds of things.

    • Setting RepeatStyle to “OnPage” and reduce the height if its not the first appearence. Did not work even with “CanShrink=True”.

    • I tried to hidden and set height to 0 to unnecessary fields for page 2+. Yes they don’t show, but the report still shows a blank space. So it did not shrink.

    • I tried keeping the “RepeatStyle” to “None” and creating a 2nd GroupHeader with only the necessary information and that group set to RepeatStyle “OnPage”. It works, but I am not able to hide that 2nd group from showing the first time. Blank space is also kept on first page.

    I played a lot with modifying the location/visible/height of the field I want to hide. But it seems the Group never Shrink. The report always keeps showing the blank space.

    Anyone has an idea on how I should accomplish that task ?

    Thank you.

    Dom.

  • Posted 24 October 2019, 7:39 pm EST

    Hello Dom,

    To achieve the said layout, you can use two groups such that they have the same DataField. Add the fields to be repeated on each page, to first group header. Set the RepeatStyle property of this group header to OnPage.

    Add the other field to the next group header and set its RepeatStyle property to None.

    A report showing the same is attached for your reference. It is bound to NWIND.mdb.

    Regards,

    Esha

    GroupReport.zip

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels