Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Subtotals in Report Footer (v2000)

    I have a report showing sales by person in the detail section and sales by region (Midwest, New England, etc.) in the group footer. I need to show sales by state for the North Pacific Region directly underneath the regional total for the North Pacific Region. How can I do this without showing state totals for the other regions, without skewing the report footer totals and without ruining the alignment of the report?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subtotals in Report Footer (v2000)

    Deshiell,

    You have to add a group footer for the region, then in the On Format event of this footer, you can set the Visible property to true for the North Pacific region and to false for all others.<pre>Private Sub GroupFooter0_Format(Cancel As Integer, FormatCount As Integer)
    If Region = "North Pacific" Then
    Me.GroupFooter0.Visible = False
    Else
    Me.GroupFooter0.Visible = True
    End If
    End Sub
    </pre>

    Francois

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subtotals in Report Footer (v2000)

    It's morning here and I must still been sleeping.
    The cod has to be :<pre>Private Sub GroupFooter0_Format(Cancel As Integer, FormatCount As Integer)
    If Region = "North Pacific" Then
    Me.GroupFooter0.Visible = True
    Else
    Me.GroupFooter0.Visible = False
    End If
    End Sub
    </pre>

    Francois

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •