MS REPORT EXPRESSIONS

Code to Print line by line:


=First(Fields!ADDRESSLINE_1.Value, "Info_TBL_CLIENTMASTER")+","+System.Environment.NewLine+First(Fields!ADDRESSLINE_2.Value, "Info_TBL_CLIENTMASTER")+","+System.Environment.NewLine +First(Fields!ADDRESSLINE_3.Value, "Info_TBL_CLIENTMASTER")+","+System.Environment.NewLine+"Tel :"+First(Fields!PHONE_1.Value, "Info_TBL_CLIENTMASTER")


Expression to hide data if data doesn't exist:


IIF(First(Fields!FAX.Value, "Info_TBL_CLIENTMASTER") Is Nothing,".",","+System.Environment.NewLine +"FAX :"+ Format(First(Fields!FAX.Value, "Info_TBL_CLIENTMASTER"))+".")