>"Strech with overflow" is checked, but it can't help me. There can be 1 to who knows how many lines in detail band and also in memofields in groupfooter. User can write more information and it should print to report. But it doesn't strech to next page. If I save this more information to variable, it will print and strech to next page. But problem is that user can write more than 254 characters.
Minna,
Try this idea:
select *, padr(substr(MemoField,1,254),254) as Memo1, padr(substr(MemoField,255,509),254) as Memo2, etc.
In you report footer put field with this expression:
Memo1; Memo2; Memo3 ...
I haven't tried it, so this is just an idea, but probably worth to try.
If it's not broken, fix it until it is.
My Blog