Report header continuation problem

[LLB]

This problem was posted last September.

Okay guys here is the question Im building this report and I want the report header to repeat like in top of each page to see where the details belong to right. The thing is I clicked on the report header properties and changed "repeat section" to Yes. And it does what i want the problem is that where the header is a continuation on top of page I would like that is says something like "(continued)" to aknowledge that what it appears on top was not the begining of the section but a continuation. Hope you understand what i mean. Please help me out guys!

This was the solution offered:

Could you make the Report header the Page Header and include the page number?

I am having the exact same problem and this solution was not able to fix it for me. I have a report listing project grouped by Project Engineer. Some of the Engineers projects continue over 2 or 3 pages and there are sums at the end of the list per engineer. I would like the 2nd page of Engineer "A" to say "Continued" or "2 of 2" even though there is 25 pages in the entire report of 8 Engineers.

Is this possible? Thanks for your time.

 

[LLB]

Thank you Pat for your reply... but I was not able to get it to work. I did a little more serching and found this reply from yourself to a similar question and I was able to get it to work.

Here is the code I use in one report. It goes in the format event of the group header. Make sure that you define the variable as static so that it will retain its value between executions:

Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)
Static strLastValue As String
If Me.txtFirstLetter = strLastValue Then
    Me.txtContinued.Visible = True
    Me.txtContinued = "Continued"
Else
    Me.txtContinued.Visible = False
    strLastValue = Me.txtFirstLetter
End If
End Sub

Also, make sure that the RepeatSection property is set to Yes.

Thanks for everything.

Lori