Report header Vs Page header... and footer! Help!

[pduran]

Hi all

I believe some of you will laught with this question but i cant find the way to do this!!!

I'm trying to create an invoice (report), with a header (firm logo and client data), detail section that can be extensive and variable (3 or 4 pages, or just one!), and a footer.
That footer must have the totals just in the last page! If the page is not the last it shoud show page x of y.
If the detail section is more than one page, i'd like to have the header again in the next page.

something like this:

Only one page
-header
-detail
-footer with totals

Two pages (or more)
1st page
- header
- detail
- footer (more information... page x of y)
2nd page
- header again
- detail
- footer with totals

Please help me!
thanks
Pduran

 

[KenHigg]

Using View>Report Header/Footer and View>Report Header/Footer you can set these up pretty much anyway you need so I'm not sure what the problem is...?

 

[pduran]

Hi Ken

thanks for your reply

I've already tried View page header/footer and report header/footer but only get the message "deleting these sections will also delete all controls in them" and cancel.

Pduran

 

[KenHigg]

It's pretty simply: You want some items to appear once per report and other things to appear once per page. Then you have the report detail area. It looks to me like you need to remove the report header/footer stuff and do it all in the page header/footer section...

If you have done a lot of work on the report and don't want to risk losing it by manipulating the report and page sections the make a copy of it and tinker with the copy.

 

[pduran]

Ken

If i work only with page header and foot header how can i have 2 different foot? For several pages of detais, i'll need foot with the information that theres another page and another foot with the totals for that detail.
Is this possible only with page header/footer?

Thanks
Pduran

 

[Rich]

You need to add a Group footer

 

[KenHigg]

Ken

If i work only with page header and foot header how can i have 2 different foot? For several pages of detais, i'll need foot with the information that theres another page and another foot with the totals for that detail.
Is this possible only with page header/footer?

Thanks
Pduran

You can put something like the followig in a tect box's control source:

="Page " & [Page] & " of  " & [Pages]

Then as far as totals, I think Rich's suggestion is what you need -

 

[GregG]

Only one page
-header
-detail
-footer with totals

Two pages (or more)
1st page
- header
- detail
- footer (more information... page x of y)
2nd page
- header again
- detail
- footer with totals

Please help me!
thanks
Pduran

Ok, give this a try:

1) Create a Page Header section.
The Page Header will have the company logo, etc and the customer name, address, etc.

2) Create a Customer Footing section.
The Customer Footing section will have a textbox called CustTotal with a control source of =Sum([DetailLineAmount]) (Be sure to use your field name here)

Right click on Customer footing section, properties and set Visible to No

3) Create a Page Footer section.

The Page Footer section will have:

a textbox called InvoiceTotal with a control source of =CustTotal
a textbox called MoreInfo with a control source of = "More information to follow"
a textbox called PageCounter with a control source of
="Page " & [Page] & " of " & [Pages]

Right click on Page Footer section, Build Event, Code Builder and Ok.
In PageFooterSection_Format type:

If Me.Page = Me.Pages Then
InvoiceTotal.Visible = True
MoreInfo.Visible = False
Else
InvoiceTotal.Visible = False
MoreInfo.Visible = True
End If


I think this will do what you need to do. If you have any additional questions you can PM me.

Good luck.