Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strings and Formulas
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Crystal Reports
Title:
Strings and Formulas
Miscellaneous
Thread ID:
00803173
Message ID:
00803173
Views:
35
{openorder.DESTNAME} & chr(13) & {openorder.ADDRESS1} & chr(13) & {openorder.ADDRESS2} & chr(13) & {openorder.CITY} & ", " & {openorder.STATE} & " " & {openorder.ZIP} & chr(13) & {openorder.COUNTRY} & chr(13) & {openorder.PHONE1}

This yields a blank field apparently because phone1 or address2 is empty. Why?

I tried using separate fields to build the address and suppress empty report header sections but when I try to draw box around the fields across the header sections it cuts the box up and shows a line between suppressed sections of the box.

I want an address in the header of the report with address2 suppressed and the line not printed if the field is empty with a box around the completed address with phone and sized properly around the address with no line painted through the center of the box. Can it be done?
Eric Kleeman - EDS Consulting Services
MCP Visual FoxPro
MCSD C#.NET
Hua Hin Thailand
Los Angeles California
Reply
Map
View

Click here to load this message in the networking platform