Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Full Page Report
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00460854
Message ID:
00461179
Views:
16
>I need to create a daily report with varying numbers of records in the detail band. What do I do to make the report fill the page with blank lines until the page summary, where I have a Total? We want this to look like a standard form was completed.
>
>Thank you in advance.
>
>/Steve


Steve,

I agree with Martin. In your program that calls the report, put the following code.
SELECT < your table >
SET ORDER TO < whatever index you want >
GOTO BOTTOM
lnLastRec = RECNO()
GOTO TOP
REPORT FORM < myreport > TO PRINTER PROMPT PREVIEW
Then, place your totals in the Page Footer and put the following expression in the Print When:
RECNO() = lnLastRec
That should do it.
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