Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Do not print page footer if more than 1 page 1

Status
Not open for further replies.

pdtit

Technical User
Nov 4, 2001
206
BE
Hello,

In my report's page footer, I have txttotal, txttva and txtpayable as fields.

This prints the total of products ordered on the bottom of the page.

However, what I want to do is NOT print these boxes when I have more than 1 page.

I used the following code :

If page <> pages then
txttotal.visible = False
else
txttotal.visible = True

this works when viewing the report on the screen; however, when printing, it prints the overall total on every page.

Does anyone know a property I can use to have it not print ??

Regards,

PdtIt

 
When further investigating this, I found a solution :

I used the .visible = false property on all my fields in the page footer, and placed this code on the pagefooter_print property.

Then it worked as it was in the report before.

Answered this one to inform the others maybe having the same issue on this.

pdtIt
 
pdtit, it sounds like maybe you wanted a report footer instead of a page footer. This would print your totals only on the last page. Maq B-)
<insert witty signature here>
 
Maq,

I tested your suggestion, and it worked.

However, in case of the report footer, it places the fields in it immediately after my detail-section lignes.

In case of the page footer, it prints me empty fields, and only on the last page, the fields are filled.
Is there any option I can make it on a fixed place on the last page if possible ?

I'll remember your answer/option, it's handy for some other reports I have.

Regards,

PdtIt
 
Hmmm, I don't think it's possible to adjust the report footer location, except by padding it with empty spaces in the footer, but that can cause other problems if you have a different number of records in the detail with each print.

Sounds like your original solution is the way to go if you absolutely have to have the footer at the bottom of the page. Maq B-)
<insert witty signature here>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top