Page Footer

[greymonkey]

Hi there,

I have a group in my report which can run over several pages and i want a footer on the last page in that group.

is there any what of setting the page footer to only be shown when the group footer is on the page or is there a way of setting the group footer to show from the bottom of the page.

any ideas
cheers,
:>

 

[PaulBricker]

This is how I ended up doing it.
1. Add a textbox to your detail section(I'll call Text0). Set the Control Source to =1, set the Running Sum property to Over Group and set the Visible property to No.
2. Add a textbox to your Page Footer. Set it's Control Source to =Text0 (the name of the textbox in 1 above). I'll call this textbox Text2. Set it's visible property to No.
3. In the Format Event for the PageFooterSection, put this code.
If Text2 = 0 Then
Else
Cancel = True
End If


That should do what you want.

Paul

 

[greymonkey]

Paul,

Great help,

cheers
:>

 

[greymonkey]

Sorry just been working through it all and it works fine untill you get the last page.

i am thinking that it is because there is no next record to reset the running sum back to 0.

any ideas how to get round this problem

 

[PaulBricker]

Haven't tried this but ist should work

If Text2 = 0 Or Me.Page = Me.Pages Then
Else
Cancel = True
End If


Paul

 

[CosmoKramer]

Or:

If Me.Page <> Me.Pages Then
   Cancel = True
End If

Hoc nomen meum verum non est.