I'm using CR 10. I have a report that has a simple formula that formats a customers address information. The address isn't showing up on the report. The problem is that all the records have data in them except for some of the Address2 and Address3 data fields. I've tried dropping the individual Contact fields onto the report and it works fine. Here is the formula below.
What am I doing wrong. I'm using Basic Syntax for all my formulas.Code:Dim strformula as String if {AR_Customer.CustomerName} <> "" then strformula = {AR_Customer.CustomerName} & chr(13) + chr(10) end if if {AR_Customer.AddressLine1} <> "" then strformula = strformula & {AR_Customer.AddressLine1} & chr(13) + chr(10) end if if {AR_Customer.AddressLine2} <> "" then strformula = strformula & {AR_Customer.AddressLine2} & chr(13) + chr(10) end if if {AR_Customer.AddressLine3} <> "" then strformula = strformula & {AR_Customer.AddressLine3} & chr(13) + chr(10) end if if {AR_Customer.City} <> "" then strformula = strformula & {AR_Customer.City} & ", " end if if {AR_Customer.State} <> "" then strformula = strformula & {AR_Customer.State} & " " end if if {AR_Customer.ZipCode} <> "" then strformula = strformula & {AR_Customer.ZipCode} end if formula = strformula
Thanks,




Reply With Quote