Limited characters from memo field in report.

[DanWalter]

I seem to be hitting a limit of 4640 characters from a memo field in a VFP report. It's a pretty complex report, 6 dbf's and 2 SQL selects, but the memo is from a single record VFP table.

TIA,
Dan Dan Walter
DWalter@zoo.uvm.edu

 

[jimstarr]

Hi Dan,

What do you mean by "hitting a limit"?

Jim

 

[DanWalter]

The report is printed in landscape. The memo field is in the title band. When the memo field reaches the bottom of the page, a second page is generated containing only the report summary band. All the rest of the data from the memo field and all the page header and all the detail band is "skipped".

Dan
Dan Walter
DWalter@zoo.uvm.edu

 

[jimstarr]

Hi Dan,

Your problem has to do not with the number of characters, but with the title band being larger than a page. (Try it with a smaller font - you'll get more characters printed.)

The report generator is notoriously bad with things like this. I think you'll need to work around it somehow. Maybe you can figure out some "print when" logic that would enable you to use the page header band instead.

Jim

 

[ramani]

HI (Jim.. I was about to suggest that... but will this work has to be tested)...

Instead of having that in the header band, shift it to details band. Then in its Print When class.. put the code... _pageNo = 1

I have done this type of printing, but never had the occasion to print a matter with more than one page volume !

Hope this idea helps ramani :-9
(Subramanian.G),FoxAcc, ramani_g@yahoo.com