Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo fields printing problem
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01249698
Message ID:
01249814
Views:
20
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform