Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Details flow into Footer when not last page
Message
 
To
22/05/2003 12:03:58
Yh Yau
Ingenuity Microsystems Sdn Bhd
Kuala Lumpur, Malaysia
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00791499
Message ID:
00791734
Views:
19
This message has been marked as the solution to the initial question of the thread.
>Cathy,
>Is that a workaround, I'm thinking of moving the items in the page footer into the group footer and putting something in the group footer to flush it to the bottom of the page. Only thing is that I haven't figured out that something..
>Yau

The way to flush the Data Footer to a specific position at the bottom of the page is kind of tricky. You have to create a report variable that counts the number of detail lines printed on the page. You also have to make sure that NOTHING on the page has "stretch w/ overflow" checked because you have to be able to assume each detail line is a certain height. You also have to be able to assume that nothing in the Page Header or Group Header stretches either.

Once you know how many lines printed .. in the Group Footer band ... you can add an object that has an expression as follows:

REPLICATE(CHR(13), 99-rnLines)

where 99 is the total number of detail lines that will fit .. and rnLines is the report variable you defined to count. You also have to make sure that if a certain data group overflows to a second page .. you have to clear the line counter .. although .. if you have a group header .. this opens up another can of worms!!

Like I said .. it's tricky .. but it can be done!!

Cathy
Cathy Pountney, Microsoft Visual FoxPro MVP
Memorial Business Systems, Inc. (www.mbs-intl.com)

My Website: (www.frontier2000.com)
My Blog: (www.cathypountney.blogspot.com)
My Book: The Visual FoxPro Report Writer - Pushing it to the Limit and Beyond
Free MSDN Article: What's New in the VFP 9.0 Report Writer
Free MSDN Article: The VFP 9.0 Report Writer In Action
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform