Share
ReportHi ,
I am trying to show CustomerName,Address1,Address2,Address3 and (city,state,zipcode) together.
e.g. CustomerName
Address1
Address2
Address3
city+state+zipcode
Sometime, Address3 can be empty in database. At that time I want to show like this. Instead of Address3, the next field should be replaced.
e.g. CustomerName
Address1
Address2
city+state+zipcode
The following Exp is now I am trying to use.
Exp=Fields!CUSTNAME.Value & vbcrlf &Fields!ADDRESS1.Value & vbcrlf & Fields!ADDRESS2.Value & vbcrlf &
Fields!ADDRESS3.Value & vbcrlf & Fields!CITY.Value & Fields!STATE.Value & Fields!ZIPCODE.Value
Please give me instruction to take out Address3 and to replace the next field instead of Address3.
*This post is locked for comments
All responses (
Answers (
3