Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Positioning of Summary Band On a report
Message
 
To
27/04/2005 04:43:26
Brian O'Donovan
Crescent Computers
Cork, Ireland
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 8 SP1
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01008756
Message ID:
01008817
Views:
16
I have two suggestions to try. The first idea is to put the totals in the Page Footer and use Print When logic to only print it on the last page. You can figure out the last page by defining a report variable called rlLast, set the expression to .f.. In the data group OnExit expression, put this line of code: _VFP.SetVar('rlLast', .t.). Now you can check rlLast in the Print When logic in the page footer. Of course, this assumes you have a data group on something such as the Invoice Number.

Another suggestion to try will only work if you do NOT have any stretchable fields in the detail band. Basically, you have to figure out how many detail lines fit and keep track of the number of lines printed with a report variable. Then, at the beginning of the report summary, you have to put a line with an expression something like this: REPLICATE(CHR(13), (maxlines) - rnLinesPrinted). Make sure the line is marked as stretch with overflow and everything else in the summary band is float. This should fudge a bunch of blank lines so the rest of the summary band starts where you want it.

I hope this helps,
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
Reply
Map
View

Click here to load this message in the networking platform