General information
Category:
Reports & Report designer
>>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.
This table has about 50 fields. Is there a way to get them all into the SELECT statement that is more clever than saying
SELECT keyfield, 1 as listorder, field1,field2...field10,;
field11,field12...field20,;
...
field41,field42...field50,SPACE etc.?
If not I can live with it.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only