Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Access 97 - Reports, making Group Headers repeat at top of new pag

Discussion in 'Information Technology' started by Molly_O, Jul 28, 2006.

  1. Molly_O

    Molly_O
    Expand Collapse
    Guest

    Hi, I was wondering if anyone knows the answer to this:
    When using Sorting and Grouping, and putting in a Group Header, is there a
    way of getting Access to repeat the Group Header at the top of a new page.

    It doesn't work to use the page header as the Detail can change half way
    through a page, therefore, you need a group header. I've tried putting the
    same headings in the Page and Group header, but then sometimes they appear
    twice due to how the data falls.
     
  2. Loading...


  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Take a look at the properties of the Group Header section. There's a
    RepeatSection property on the Format tab (or on the All tab, of course!)

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Molly_O" <Molly_O@discussions.microsoft.com> wrote in message
    news:E46DB8E5-F063-490E-A938-D0BDB1CD63C1@microsoft.com...
    > Hi, I was wondering if anyone knows the answer to this:
    > When using Sorting and Grouping, and putting in a Group Header, is there a
    > way of getting Access to repeat the Group Header at the top of a new page.
    >
    > It doesn't work to use the page header as the Detail can change half way
    > through a page, therefore, you need a group header. I've tried putting

    the
    > same headings in the Page and Group header, but then sometimes they appear
    > twice due to how the data falls.
     
  4. Molly_O

    Molly_O
    Expand Collapse
    Guest

    Re: Access 97 - Reports, making Group Headers repeat at top of new

    I did try this, and it works up to a point, but the problem with it is if one
    of your "values" comes to an end at the bottom of a page, then the group
    header for that value gets put onto the next page, with nothing below it.
    Then it goes onto the next value.

    For example, my Tracker rate products finish on page one, but at the top of
    page 2, it shows Tracker in the group header - with nothing below it, then
    goes onto my Variable rate products. Any more thoughts

    "Douglas J Steele" wrote:

    > Take a look at the properties of the Group Header section. There's a
    > RepeatSection property on the Format tab (or on the All tab, of course!)
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "Molly_O" <Molly_O@discussions.microsoft.com> wrote in message
    > news:E46DB8E5-F063-490E-A938-D0BDB1CD63C1@microsoft.com...
    > > Hi, I was wondering if anyone knows the answer to this:
    > > When using Sorting and Grouping, and putting in a Group Header, is there a
    > > way of getting Access to repeat the Group Header at the top of a new page.
    > >
    > > It doesn't work to use the page header as the Detail can change half way
    > > through a page, therefore, you need a group header. I've tried putting

    > the
    > > same headings in the Page and Group header, but then sometimes they appear
    > > twice due to how the data falls.

    >
    >
    >
     
  5. kabaka

    kabaka
    Expand Collapse
    Guest

    Re: Access 97 - Reports, making Group Headers repeat at top of new

    In the grouping & sorting dialog box (where you determine the sort order for
    your data, whether there are group headers, footers, etc.) you can select
    "keep together" which should prevent a header to appear on a page without
    data. Failing that, a similar option is available under the properties of
    the header itself.



    "Molly_O" wrote:

    > I did try this, and it works up to a point, but the problem with it is if one
    > of your "values" comes to an end at the bottom of a page, then the group
    > header for that value gets put onto the next page, with nothing below it.
    > Then it goes onto the next value.
    >
    > For example, my Tracker rate products finish on page one, but at the top of
    > page 2, it shows Tracker in the group header - with nothing below it, then
    > goes onto my Variable rate products. Any more thoughts
    >
    > "Douglas J Steele" wrote:
    >
    > > Take a look at the properties of the Group Header section. There's a
    > > RepeatSection property on the Format tab (or on the All tab, of course!)
    > >
    > > --
    > > Doug Steele, Microsoft Access MVP
    > > http://I.Am/DougSteele
    > > (no e-mails, please!)
    > >
    > >
    > > "Molly_O" <Molly_O@discussions.microsoft.com> wrote in message
    > > news:E46DB8E5-F063-490E-A938-D0BDB1CD63C1@microsoft.com...
    > > > Hi, I was wondering if anyone knows the answer to this:
    > > > When using Sorting and Grouping, and putting in a Group Header, is there a
    > > > way of getting Access to repeat the Group Header at the top of a new page.
    > > >
    > > > It doesn't work to use the page header as the Detail can change half way
    > > > through a page, therefore, you need a group header. I've tried putting

    > > the
    > > > same headings in the Page and Group header, but then sometimes they appear
    > > > twice due to how the data falls.

    > >
    > >
    > >
     
  6. Molly_O

    Molly_O
    Expand Collapse
    Guest

    Re: Access 97 - Reports, making Group Headers repeat at top of new

    Tried that! For some reason it seems to be that when you switch on the
    "RepeatSection" property, it repeats at the top of the next page when the
    value ends exactly at the bottom of the page before.

    "kabaka" wrote:

    > In the grouping & sorting dialog box (where you determine the sort order for
    > your data, whether there are group headers, footers, etc.) you can select
    > "keep together" which should prevent a header to appear on a page without
    > data. Failing that, a similar option is available under the properties of
    > the header itself.
    >
    >
    >
    > "Molly_O" wrote:
    >
    > > I did try this, and it works up to a point, but the problem with it is if one
    > > of your "values" comes to an end at the bottom of a page, then the group
    > > header for that value gets put onto the next page, with nothing below it.
    > > Then it goes onto the next value.
    > >
    > > For example, my Tracker rate products finish on page one, but at the top of
    > > page 2, it shows Tracker in the group header - with nothing below it, then
    > > goes onto my Variable rate products. Any more thoughts
    > >
    > > "Douglas J Steele" wrote:
    > >
    > > > Take a look at the properties of the Group Header section. There's a
    > > > RepeatSection property on the Format tab (or on the All tab, of course!)
    > > >
    > > > --
    > > > Doug Steele, Microsoft Access MVP
    > > > http://I.Am/DougSteele
    > > > (no e-mails, please!)
    > > >
    > > >
    > > > "Molly_O" <Molly_O@discussions.microsoft.com> wrote in message
    > > > news:E46DB8E5-F063-490E-A938-D0BDB1CD63C1@microsoft.com...
    > > > > Hi, I was wondering if anyone knows the answer to this:
    > > > > When using Sorting and Grouping, and putting in a Group Header, is there a
    > > > > way of getting Access to repeat the Group Header at the top of a new page.
    > > > >
    > > > > It doesn't work to use the page header as the Detail can change half way
    > > > > through a page, therefore, you need a group header. I've tried putting
    > > > the
    > > > > same headings in the Page and Group header, but then sometimes they appear
    > > > > twice due to how the data falls.
    > > >
    > > >
    > > >
     
  7. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    Re: Access 97 - Reports, making Group Headers repeat at top of new

    Try putting this in the Group Section's Format Event (no guarantees though)

    Private Sub GroupHeader1_Format(...)
    Static LastVal As String

    If FormatCount >1 Then Exit Sub
    If Len(LastVal)=0 Then
    LastVal = Me.[HeaderField] ' subsitute
    exit Sub
    Else
    Cancel = LastVal<>Me.[HeaderField]
    LastVal = Me.[HeaderField] ' subsitute
    End If
    End Sub

    HTH

    Pieter


    "Molly_O" <MollyO@discussions.microsoft.com> wrote in message
    news:3D1CDFE5-21C4-4FC9-B736-7AD0C0D32D6C@microsoft.com...
    > Tried that! For some reason it seems to be that when you switch on the
    > "RepeatSection" property, it repeats at the top of the next page when the
    > value ends exactly at the bottom of the page before.
    >
    > "kabaka" wrote:
    >
    >> In the grouping & sorting dialog box (where you determine the sort order
    >> for
    >> your data, whether there are group headers, footers, etc.) you can select
    >> "keep together" which should prevent a header to appear on a page without
    >> data. Failing that, a similar option is available under the properties
    >> of
    >> the header itself.
    >>
    >>
    >>
    >> "Molly_O" wrote:
    >>
    >> > I did try this, and it works up to a point, but the problem with it is
    >> > if one
    >> > of your "values" comes to an end at the bottom of a page, then the
    >> > group
    >> > header for that value gets put onto the next page, with nothing below
    >> > it.
    >> > Then it goes onto the next value.
    >> >
    >> > For example, my Tracker rate products finish on page one, but at the
    >> > top of
    >> > page 2, it shows Tracker in the group header - with nothing below it,
    >> > then
    >> > goes onto my Variable rate products. Any more thoughts
    >> >
    >> > "Douglas J Steele" wrote:
    >> >
    >> > > Take a look at the properties of the Group Header section. There's a
    >> > > RepeatSection property on the Format tab (or on the All tab, of
    >> > > course!)
    >> > >
    >> > > --
    >> > > Doug Steele, Microsoft Access MVP
    >> > > http://I.Am/DougSteele
    >> > > (no e-mails, please!)
    >> > >
    >> > >
    >> > > "Molly_O" <Molly_O@discussions.microsoft.com> wrote in message
    >> > > news:E46DB8E5-F063-490E-A938-D0BDB1CD63C1@microsoft.com...
    >> > > > Hi, I was wondering if anyone knows the answer to this:
    >> > > > When using Sorting and Grouping, and putting in a Group Header, is
    >> > > > there a
    >> > > > way of getting Access to repeat the Group Header at the top of a
    >> > > > new page.
    >> > > >
    >> > > > It doesn't work to use the page header as the Detail can change
    >> > > > half way
    >> > > > through a page, therefore, you need a group header. I've tried
    >> > > > putting
    >> > > the
    >> > > > same headings in the Page and Group header, but then sometimes they
    >> > > > appear
    >> > > > twice due to how the data falls.
    >> > >
    >> > >
    >> > >
     

Share This Page