>I need to print a lot of text fields on a page for each record, then print a memo (when not blank) on the following page. There will also be a page header. If I make the detail band longer than the page, it tells me so and refuses to print. If I group the data so that every record is a group, and put the memo field in a group footer, the memo field prints before the detail band. Maybe I'm missing something obvious, but I can find no way to make every record print on two pages.
Duplicate records:
SELECT key,1 as listorder,field1,field..,SPACE(254) as memo From Table1 Into Cursor tmpReport UNION SELECT key,2 as listorder,"" as field1, "" as field2....,memo From Table1
Then print group report (group by key,listorder) with each group starting new page.
Edward Pikman
Independent Consultant