Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Memo fields printing problem
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01249698
Message ID:
01249814
Vues:
21
This message has been marked as a message which has helped to the initial question of the thread.
One idea is to try combined the fields that are stacked into one object on the report, marked as stretchable, with an expression like this:
ALLTRIM(mProblem);IIF(EMPTY(mResolution), '', 'Comments: ' + ALLTRIM(mResolution))
The ";" is used as a special character in reports to concatenate two expression with a CHR(13) between them, but if one is blank, it doesn't add the CHR(13). Because you have a label in the second line, I used the IIF() command to figure out that line.




>>The reason this is happening is because the entire line is not blank. You still have iTicket_ID on that line.
>>
>>One trick is to put some print when logic on iTicket_ID to suppress it if Problem and Resolution are both blank. Then add iTicket_ID again on the 2nd line and put logic that is opposite so it only prints when both Problem and Resolution are blank.
>>
>
>Thanks a lot, the idea worked. It worked for cases where I don't have mGeneric_Problem and mGeneric_Resolution, so now it prints correctly:
>
>iTicket_ID  Comments: mProblem               Comments: mResolution
>
>However, I also want to achieve the following:
>
>iTicket_ID   mGeneric_Problem               Comments: mResolution
>
>In other words, if only mGeneric_Problem is missing or only mGeneric_Resolution is missing I'd like the empty line not printed even for this case.
>
>I'm wondering if this is possible too?
>
>Thanks a lot in advance.
Cathy Pountney, Microsoft Visual FoxPro MVP
Memorial Business Systems, Inc. (www.mbs-intl.com)

My Website: (www.frontier2000.com)
My Blog: (www.cathypountney.blogspot.com)
My Book: The Visual FoxPro Report Writer - Pushing it to the Limit and Beyond
Free MSDN Article: What's New in the VFP 9.0 Report Writer
Free MSDN Article: The VFP 9.0 Report Writer In Action
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform