Big memo field whacks my report

[DanWalter]

I have a VFP report that is pretty complex - 6 tables in data environment and two SQL Selects feeding it as well. In the report title band is a memo field. The report is printed in landscape mode. When the memo extends to the bottom of the page, the rest of the report seems to kind of "abort", and all I get is the page number. No page header, no detail band, no page footer, no report summary.
The magic number (but this is probably determined by font and page orientation more than anything else) is 4640 characters from the memo field.

Any ideas?

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

 

[alank01]

my understanding of the report header is that it behaves like any other group band that has reprint header on each page checked. with such a large page header you are asking the report writer to reprint the page header before a new page has triggered (i guess a sort of loop). i suggest you abandon the page header proper and make another group band myheader without reprint group header on each page. set up a varible myheader inital value space(1) and then add group band iif(.t.,myheader,''). this group will change (trigger) only at the begining of the report. your can then have a large a title as you require. what about the pages in between? there would not be any detail anyway only header. if you need to have a shortened title on each page again set up another band based on variable mypage which is equal to the calculation (*)count _pageno and the group will trigger change on each page and then print what you need. the "print when" function for this band would be when _pageno # 1 because you already have your main title. if the header is by exception very large i would use memlines() and set('memowidth') on the cursor to determine the size of the header before running the report and if its less than 45 lines for example use your normal report form otherwise try the other one.

 

[DanWalter]

Thanks. I'll probably just move the memo field into it's own report so that it's all detail band, then print it after the main report.

Dan Dan Walter
DWalter@zoo.uvm.edu

 

[Guest_imported]

Economics :an introduction to analysis and policy /George Leland Bach, with the assistance of David J. Teece.10th ed.Prentice-Hall,Englewood Cliffs, New Jersey :c1980.

736 p.


*****************************************************

see the above problem?theres has to be no space between the long text and the number of pages.i mean the text (736 p.)should be below the line (ed.Prentice-Hall.....) with the same indention as the (Economics: an .....)