Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Limit Size of Printed Memo Field
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
Visual FoxPro:
VFP 9
Database:
Visual FoxPro
Divers
Thread ID:
01058094
Message ID:
01058119
Vues:
16
>I created a report with report designer. One field is a memo field which can obviously be quite large. I want to limit the number of characters that will print to keep the field from going across multiple pages.
>
>If I were printing manually I could use the mline function and a loop to just print the first N lines of the field. But how do I do something similar with report designer running against a table?
>
>Regards, Lou

Lou,
to limit number of lines try this:
n_lines = max_lines_to_print
? IIF(MEMLINES(your_memo)<=n_lines,;
               your_memo,;
               SUBSTR(your_memo,1,AT(CHR(13)+CHR(10),your_memo+IIF(ASC(Right(your_memo,1))=10,'',CHR(13)+CHR(10)),n_lines)))
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform