Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Page problems
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Miscellaneous
Thread ID:
00052624
Message ID:
00052654
Views:
29
>>In regards to this Memo Problem... I handled this once before, but at another job so unfortunately I cant go back and look to see exactly how I did it. But the trick here is to use the MEMLINES() function inside the Report Form. From what I remember, I set the report up with a fake grouping, and I would print the memo field in its original place by embedding something like this in the memofield:
>> IIF(MEMLINES(memofield)<=19,memofield," ") &&and set to remove line if blank
>>
>>Then I also had the memofield in a second place, after my extra or fake grouping with the following embedded in the report form field:
>> IIF(MEMLINES(memofield)>19,memofield," ") &&and set to remove line if blank
>>
>>How did I manage the extra or fake grouping? I cant remember but I think you could do it by adding a field and setting a value based on MEMLINES() before generating the report. Hope That Helps =D)
>
>I am wondering, why simple checking of "Stretch with Overflow" box will not solve the problem.


Ahhh.... thats sounds much easier. The example I gave was done way back in the FP2.5 days. Your solution is probably the better answer because with mine the memos exceeding 19 lines will always be on second page and not stretched over 2 pages.
Roxanne M. Seibert
Independent Consultant, VFP MCP

Code Monkey Like Fritos
Previous
Reply
Map
View

Click here to load this message in the networking platform