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