Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Sep 2002
    Location
    London, England
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Add continued text to repeated report section (2000)

    I'd like a text box, containing the text 'continued...', to appear in a reprt group header whenever the group header has been repeated.
    I've set the Repeat Section flag for the group header to Yes and this works great, the header section is repeated at the top of each page if the group extends beyond the end of a page, but at present there is nothing to indicate that the page the user is looking at is not where a particular group starts. Will I have to reset a flag each time the group footer on format event fires, or is there another way?

    Ian

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Add continued text to repeated report section (2000)


  3. #3
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    Sacramento, CA
    Posts
    193
    Thanks
    3
    Thanked 1 Time in 1 Post

    Re: Add continued text to repeated report section (2000)

    Has anyone applied the concept to report columns? I have not been successful in my attempts to apply this example concept to columns.

    Thanks,
    Marty

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Add continued text to repeated report section (2000)

    What exactly do you want?

  5. #5
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    Sacramento, CA
    Posts
    193
    Thanks
    3
    Thanked 1 Time in 1 Post

    Re: Add continued text to repeated report section (2000)

    As data in one column spans into the next, I would like to have "continued" to appear along with the repeated Group header. Or at least something along those lines such that when a reader of the report scans across the top it's immediately obvious if the data listed is continued from the previous column.

    Marty

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Add continued text to repeated report section (2000)

    Place a label lblContinued with caption "(continued)" or similar in the group header, to the right of or below the text box that displays the group name.
    Create an On Format event procedure for the group header like the one below. I have assumed that the group is identified by a text field CategoryName, and that the group header is named GroupHeader0.

    Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)
    Dim strCurGroup As String
    Static strOldGroup As String
    ' The current group identifier
    strCurGroup = Me.CategoryName
    ' Make label visible if the group header is repeated
    Me.lblContinued.Visible = (strOldGroup = strCurGroup)
    ' Save group identifier for next time
    strOldGroup = strCurGroup
    End Sub

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Add continued text to repeated report section (2000)

    I have attached a zipped sample database demonstrating my previous reply.
    The group footer and detail sections are taller than necessary. This is deliberate, otherwise the report would be too short to show the effect of the code.
    Attached Files Attached Files

Posting Permissions

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