Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Page breaks in a report ...
Message
 
 
To
17/10/2001 17:56:08
Denis Filer
University of Oxford
United Kingdom
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00569130
Message ID:
00570021
Views:
23
>The report is a description of a museum collection. It has about 15 fields laid out to print a report around 3" wide (hence the option to have 2 columns) and from 4 to 8 " long. We print 100's of these and so maximising the number on a page is important. Some fields have 'print when' clauses and some are laid one on top of t'other using txtwidth() to position one object after another in a different font. Happy to scrap 2 columns and stick to one. But I do not want the report ("label") to flow onto next page. The reporter ought to know how long the next item will be and thus whether to throw a page. I have tried drawing an invisible box (KB article suggests to use invisible line to push Labels down after floating field). Maybe some type of data group?

Denis,

This sounds really complicated. How many memo fields per record do you have? Suppose, you have one memo field. If so, and you know the total length (height) of one record (when memo has n lines), you may calculate, do you, or you don't need to switch to another page. So, theoretically, you may scan your file, and put some flag, when you calculate you need to switch to another page. Sounds tedious and complicated, but I can not think about easier solution.

I can advise you to find Dec. 2000 and Feb 2001, March 2001 FoxTalk issues for Cathy Pountney articles about VFP Report Writer, She uses lots of very clever tricks, which may give you some idea. Unfortunately, I don't remember anything, which may apply in your situation...
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform