Print "Continued" only if the group header repeats

  • Thread starter Thread starter Brian Smith
  • Start date Start date
B

Brian Smith

I have a report with a nested group headers. In the highest group header I
have set the repeat section property to yes. I want the report to say
"(continued)" on pages where the group header has been repeated. I have
tried using the following if statement:

=IIf( Section(5).HasContinued = -1,"(Continued)","False")

False always appears on every page no matter whether or not the group header
continues onto the next page. However, no matter what I do I can't get the
has continued property to be true.

Please help me. Thank you in advance.

Brian
 
Brian said:
I have a report with a nested group headers. In the highest group header I
have set the repeat section property to yes. I want the report to say
"(continued)" on pages where the group header has been repeated. I have
tried using the following if statement:

=IIf( Section(5).HasContinued = -1,"(Continued)","False")

False always appears on every page no matter whether or not the group header
continues onto the next page. However, no matter what I do I can't get the
has continued property to be true.
Click to expand...

HasContinued only applies to a single instance of the
section, not the entire group (even then it rarely does what
we think it should).

The way I do it is to add a text box to the detail section.
Set the text box's Name to txtDetailCount, control source
expression to =1 and RunningSum to Over Group.

Then you can test the value of the text box to make the
label(?) with the word "Continued" Visible or not as needed.
Using VBA in the group header's Format event:

lblContinued.Visible = (Me.txtDetailCount > 1)
 
Back
Top