Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP3.0 Reports Wrapping to New Page Too Early
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00056067
Message ID:
00056170
Views:
28
When the report writer, in its infinite wisdom, thinks you need a page break between your stretching memo and your floating character field, you can't stop it, from what I can tell. I had a stretching memo field (in vfp3) and even though nothing was below it, I would get blank pages, or pages with just a header (if I had a page header) whenever the memo field filled half a page or so. I consider this a very serious bug. My bogus solution was to make the memo non-stretch and warn the user about the maximum size. If my user stops putting up with this, here's what I plan to do:

1) I run my report off a cursor anyway, to take care of some unusual formatting. If you want to control page breaks, you have to make everything non-stretch and non-float. If that memo has to take up unlimited space, consider splitting each memo record into a number of fixed-length records, which become children of your table. Each record in your old table becomes a group.

2) say "to hell with the report writer" and start automating word or excel, or using crystal reports, or something.

>Interesting! That *does* seem to be what's happening. The only records that are wrapping too early are those where the remainder won't be able to print on the first page. However, my client won't accept that. Is there a way to impose a programmable page break where *I* want it to go, instead of where FoxPro decides to put it itself?
>
>When this database starts being populated with live data, there will be several stretching memo fields in each record, meaning that there could be some real unpredictable results when FoxPro attempts to accomodate the records on the page(s).
>
>>then problem is that once the report writer reaches a certain point (varies), it looks at the rest of the fields that is supposed to print below that. if it can't fit all of the remaining items on what space is left, it moves everything left to the next page.
>>
>>>Thanks for writing!
>>>
>>>"field3" *is* set to FLOAT already. In fact, ALL my fields are set to float. I'm wondering whether I just need to re-create the report from scratch, to see if it will work.
>>>
>>>>try telling field3 and below to float (not fixed to top of report).
>>>>
>>>>>Greetings!
>>>>>
>>>>>I have a relatively simple report layout in VFP3.0 that contains a few
>>>>>memo fields. Each page or two contains the contents of ONE record,
>>>>>with the fields being arranged in order down the page, such as this:
>>>>>
>>>>> field1......
>>>>> field2 (memo)....
>>>>> field3.....
>>>>> ... and so on.
>>>>>
>>>>>What's happening is this: If the memo contents of field2 stretches
>>>>>past a certain point down the page, field3 is started on the next
>>>>>page, even though field3 occupies only ONE line and there is more than
>>>>>adequate room to accomodate it below field2.
>>>>>
>>>>>I cannot find any option settings that keeps this from happening. The
>>>>>wrapping does not happen on every record, but rather ONLY if field2 is
>>>>>stretches past a certain point on the page. This is frustrating,
>>>>>since the first page still has about 5 inches of blank space left
>>>>>over, even though the next field to print occupies one line!
>>>>>
>>>>>What am I overlooking?? Any help would be very appreciated. Thank
>>>>>you!
>>>>>
>>>>>Michael Reynolds
Previous
Reply
Map
View

Click here to load this message in the networking platform