Print Footer only on Last Page

I need to print a footer only on the last page of my report ? how can i do that...
also
in other report i have to print a part of footer(data is subset of the whole footer) and the whole footer on the last page.How can i do this
ThanksYou can conditionally hide what you don't want to see based on
Globals.PageNumber and Globals.TotalPages
For example, you could put the entire page footer into a rectangle and set
its Hidden property to:
=Globals.PageNumber<Globals.TotalPages
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"Sunny" <Sunny@.discussions.microsoft.com> wrote in message
news:90130113-38FE-4579-B6C9-68BDE4C40055@.microsoft.com...
> I need to print a footer only on the last page of my report ? how can i do
that...
> also
> in other report i have to print a part of footer(data is subset of the
whole footer) and the whole footer on the last page.How can i do this
> Thanks
>|||Hey thanks...i saw your other reply for similar question later on.thanks anyway
"Chris Hays [MSFT]" wrote:
> You can conditionally hide what you don't want to see based on
> Globals.PageNumber and Globals.TotalPages
> For example, you could put the entire page footer into a rectangle and set
> its Hidden property to:
> =Globals.PageNumber<Globals.TotalPages
> --
> This post is provided 'AS IS' with no warranties, and confers no rights. All
> rights reserved. Some assembly required. Batteries not included. Your
> mileage may vary. Objects in mirror may be closer than they appear. No user
> serviceable parts inside. Opening cover voids warranty. Keep out of reach of
> children under 3.
> "Sunny" <Sunny@.discussions.microsoft.com> wrote in message
> news:90130113-38FE-4579-B6C9-68BDE4C40055@.microsoft.com...
> > I need to print a footer only on the last page of my report ? how can i do
> that...
> > also
> > in other report i have to print a part of footer(data is subset of the
> whole footer) and the whole footer on the last page.How can i do this
> >
> > Thanks
> >
>
>