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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

field missing off report

Status
Not open for further replies.

Bertiethedog

Programmer
Feb 8, 2007
118
GB
I have a stretchy line in a report which contains the terms & conditions.

It is in the page footer area and contains 24 lines of text which should push it into page 2.

Unfortunatly nothing is printed.

Anyone have any ideas


Richard
 
My first guess is that PAGE FOOTERS are not designed to wrap from Page to page. SO since it is to big to fit in the area alloted for the footer, It does not print at all.
You might have to increase the size of the footer area where it is big enought to print on the bottom of every page. But from your statement that is not what you want it to do.

David W. Grewe Dave
 
Bertie,

If you really want to wrap the footer across two consecutive pages, you might need to split it into two fields in the table. Add both fields to the footer, and use a Print When to force them to print on alternative pages.

If you don't want to wrap the footer, do as David suggested. Make the page footer band tall enough to hold the whole thing, and also make sure you have a bit of blank space between the text and the bottom of the band.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk
 
Sounds like this report might be some sort of contract?... anyway I think you might want to put the terms and conditions in a summary band that will print at the end of the report...

Andy Snyder
SnyAc Software Services
 
Thanks everyone for your help

The report is a quotation and they wanted to put 24 lines of text on the bottom. I overcame it by stretching the report and placing it in the footer.

I couldn't just type the text in as the customer wanted the ability to change the t&c's. Personally I would have prefered to use a word template but they didn't like that in case word changed in the future & was not compatable with FoxPro

Richard
 
This is how I solved it

I created a group Put the top part of the quote in the group header and the T&C's in the group footer. I had to be careful about "Floating" otherwise the fields in the group header would vanish.

The T&C's will wrap onto the next page no problem.

I still think a word template would have been more effective, but he who pays the piper etc
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top