Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
To prevent memo from splitting between pages
Message
From
15/08/2003 04:46:47
 
 
To
15/08/2003 00:33:39
Vladimir Zhuravlev
Institute of the Physics of Earth,Russia
Moscow Region, Russia
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00820395
Message ID:
00820408
Views:
20
Consider OCCURS(CHR(13),cursor.MemoField) in your formula.

>There is report one to many
>Details band has regular field ( char or int) and memo with some leght placed under it in the report ( with stretch check )
>This memmo can have few 'enters' ( char(13)), which can be detected by mline() or
>aline() functions and also some frases without this simbol, more wide, than memo width in the report
>In the result of stretch memo can have few lines
>I need to prevent the plitting of the memo between pages for one record and show it only on the same page, as regular field
>Due to different memo width for different records one page can show potetionally different number of the records
>I entered report variable, counting the sum height of all memos and regular field ( this is formula having txtwidth() and mline() , I opened frx before like regular table and read fontsize, fontname, expression width for memo to use in this formula)
>and tried to make group with this variable something like int(_ln/35)
>35 is normal numbers of report strings at page without memo
>I worked good, but when I entered more 'enters' in the memos inside frases,
>it started again to be splitted between pages.
>Is it any more reliable way to prevent it.
>Thanks in advance, Vladimir
----------------------------------
António Tavares Lopes
Previous
Reply
Map
View

Click here to load this message in the networking platform