Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Control where a totals line appears
Message
 
To
20/01/1997 09:02:01
Jon Ziegler
Mannesmann Dematic Corp.
Solon, Ohio, United States
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00017856
Message ID:
00017862
Views:
67
> > I need to create a report where a group total line > cannot be the first line of a page. Is there an easy way (or any way, for > that matter) to insure that this will happen? Jon, Mine is rather of the 'any way' category. Look at my report object. I use it for the summary, you could extend it to group totals (if you are courageous). If there is not enough space to print the summary on the last page, the object makes sure that one line is printed on the next page. Very unOOlike, I initiate the nLPP (number of lines per page ... and yes, it takes a test run to find out) and the nSummaryLines (number of Lines taken by the Summary). In the report I set the group to this.LastPage(), with the setting on where if the value of the group value changes, the report issues a formfeed. Look at the Lastpage method: It returns 0 if 'lastpageing' is not activated, if there is enough space for the summary on the last page, and 1 if this is the last line and there is _not_ enough space on the last page. BTW, another approach is to stuff empty lines into the cursor that is submitted to the report in such a way that the group total falls where you want it to. Not always applicable obviously. HTH, Marc ***

If things have the tendency to go your way, do not worry. It won't last. Jules Renard.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform