Large Memo fields being cut short

[Peter_Zimmer_(Guest)]

I am trying to generate a User-SQL report (in R&R v12 using Oracle 9i) of process summary log entries that each have an memo field (Oracle type Long) that can be up to two pages long. ____When I run the report, the memo for the first entry prints properly, but all the remaining memos that are longer than one page truncate at the end of the first page of their respective log entry. ____I need to be able to print all of the log entries in a group. I have to be able to print all of the text out of the memo field for each entry. ____I tried this in R&R SQL v9 as well as R&R ReportWorks Infinity v12 and got the same result. ____If anyone has any ideas for me, they would be greatly appreciated!____Peter__

[kfleming]

There is a 8000 character limit in printing large memo fields and this is likely what you are running into.____Kathleen__R&R Support

[Peter_Zimmer_(Guest)]

Thanks for the reply Kathleen. ____Is that 8000 characters per record or 8000 characters for the entire report?____The memos can be large, but I don^t believe that any one of them comes close to being 8000 characters. ____Peter

[Peter_Zimmer_(Guest)]

Thanks for the reply Kathleen. ____Is that 8000 characters per record or 8000 characters for the entire report?____The memos can be large, but I don^t believe that any one of them comes close to being 8000 characters. ____Peter

[kfleming]

It is per record.____Kathleen__R&R Support

[Peter_Zimmer_(Guest)]

Thanks Kathleen. I will check to see if I am going over that limit. ____Peter____>It is per record. __>__>Kathleen __>R&R Support __