Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Only print 1st page
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00835327
Message ID:
00835426
Views:
16
I'm not sure why you are getting 2 pages .. but .. if all you really want is 30 records print the report as follows:

REPORT FORM MyReport NEXT 30 ...

The NEXT 30 clause tells it print the next 30 records so as long as you have the record pointer positioned on the first record you want and the index is set to the order you want, you will only get 30 records.

Cathy



>Hi Cathy,
>
>I'm printing directly, I really only wanted the first 30 records in the table, so I wrote some SQL to create a cursor and print the first 30 records which I thought I could do using record no? Anyway, user said first page would be fine, so I thought forget the SQL and just print with a range.
>
>I'm getting 1 full page & 5 lines on the next page. Page 2 is at the page footer?
>
>Any ideas
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