Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Memo Field
Message
De
21/06/2001 03:16:26
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
20/06/2001 15:00:09
Steven Dyke
Safran Seats USA
Texas, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Divers
Thread ID:
00521622
Message ID:
00521773
Vues:
15
>I have a report that uses a couple of memo fields. If the memo field is larger than three lines(dictated by carrage return) I loose all objects below this field. I either need a way to make the report field size dynamicly or strip all carrage returs out of the memo field before it gets to the report writer.

Steven,
Strech and float checking would take care of long memos. If you mean multiple CR within the memo + trailing CRs are a problem :
lcMemo = chrtran(myMemo,chr(13)+chr(10),chr(10)) && CRLF to LF
do while occurs(chr(10)+chr(10),lcMemo)>0 && While multipl LF exists
  lcMemo = strtran(lcMemo,chr(10)+chr(10),chr(10)) && Half the LFs
enddo
lcMemo = left(lcMemo,len(lcMemo)-iif(right(lcMemo,1)=chr(10),1,0))
This would reduce multiple consequtive CRLF to one. You could have this code slightly modified in either lostfocus of editbox (so would do it as editing done) or as a UDF just to call from a report (not a problem IMHO since in reports real botleneck is printer which is slower than fox code). And since code uses halving system which means with say 1024 CRs loop would take 10 passes I don't think you'd need faster routines like C FLLs.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform