Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remove Line if Blank (What's considered Blank)
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00727632
Message ID:
00727648
Views:
13
> It might be better to handle this as follows:

> iif(empty(field1),'',field1+chr(13)+chr(13))+iif(empty(field2),'',field2)

Kevin, the ';' separator does exactly what the IIF(EMPTY(FIELD1),'') does. It's just that I thought a CHR(13) blank line by itself would be removed using REMOVE LINE IF BLANK but from further testing it looks like it just removes objects if they are blank.
Previous
Reply
Map
View

Click here to load this message in the networking platform