Show "Continued" when detail is split

[DavPet]

My report lists work orders completed, grouped bySupervisor name.
I have the Supervisor field set to "Keep together with first detail".
When the detail spans across a page break, the Supervisor name shows at the
top of the continued page (exacly right), then the rest of the work orders.

How can I make the report say "John Doe - Continued" ??

 

[Marshall Barton]

My report lists work orders completed, grouped bySupervisor name.
I have the Supervisor field set to "Keep together with first detail".
When the detail spans across a page break, the Supervisor name shows at the
top of the continued page (exacly right), then the rest of the work orders.

Let's try adding a text box named txtDetail to the detail
section. Set its control source expression to =1 anf
RunningSum property to Over Group.

Then use some code in the Format event of the section that
that displays the supervisor name on the second page (the
group header if you're using Repeat Section, otherwise the
page header).

If Me.txtDetail = 1 Then
Me.txtSupervisorName = Me.Supervisor
Else
Me.txtSupervisorName = Me.Supervisor & " (continued)"
End If

 

[Guest]

I used this function and it works well when the title is the same on each
section. But when my title changes, it still carries the " (continued)". How
can I force it to go back?

 

[Marshall Barton]

I used this function and it works well when the title is the same on each
section. But when my title changes, it still carries the " (continued)". How
can I force it to go back?

The code I posted takes care of that.

One reason why it might not is that the previous name has
something to display on the page where a different
supervisor's data starts. Does your supervisor group header
section have its ForceNewPage property set to Before
Section?

 

[Guest]

No. I don't want them to break between sections.

 

[Marshall Barton]

No. I don't want them to break between sections.

Well then, isn't the one supervisor group continued on the
same page as the next supervisor group starts? Seems like
every page except the first will have <continued> if there
is no page break between two supervisor groups.

Maybe I am not following what you are trying to explain??

 

[Guest]

When I tried it with your setup, it put "continued" on the new supervisor
even though it was a new name.

I've since fixed the problem by adding another running sum field called
HdrCount to run in an IF statement indicating when it goes to a new name not
to do the "continued" process.

So.. I found my own work around.

 

[Marshall Barton]

When I tried it with your setup, it put "continued" on the new supervisor
even though it was a new name.

I've since fixed the problem by adding another running sum field called
HdrCount to run in an IF statement indicating when it goes to a new name not
to do the "continued" process.

So.. I found my own work around.

I still don't understand what the issue is, but if it works
that's ok.