I have never done these type before... these are crystal expression and i need them to be converted to SSRS...Thank you 1.) if IsNull ({VW_RPT_MOVEVALIDATION.OWNER_CONTACTNAME}) then {VW_RPT_MOVEVALIDATION.OWNER_COMPANYNAME} else trim({VW_RPT_MOVEVALIDATION.OWNER_CONTACTNAME}) & ", " & trim({VW_RPT_MOVEVALIDATION.OWNER_COMPANYNAME}) 2.) Move count totext({VW_RPT_MOVEVALIDATION.QTY},0) + (if {VW_RPT_MOVEVALIDATION.MATERIALTYPEID} = 7 or {VW_RPT_MOVEVALIDATION.MATERIALTYPEID} = 10 then "" else ( " Joints " + "(" + totext({VW_RPT_MOVEVALIDATION.LENGTH},2) + " FEET/METERS)")) 3.) @oldnew service if isnull({VW_RPT_MOVEVALIDATION.OLDSERVICECODE}) and not isnull({VW_RPT_MOVEVALIDATION.SERVICECODE}) then "New SvcCd# " + {VW_RPT_MOVEVALIDATION.SERVICECODE} else if isnull({VW_RPT_MOVEVALIDATION.SERVICECODE}) and not isnull ({VW_RPT_MOVEVALIDATION.OLDSERVICECODE}) then "Old SvcCd# " + {VW_RPT_MOVEVALIDATION.OLDSERVICECODE} else "Old SvcCd# " + {VW_RPT_MOVEVALIDATION.OLDSERVICECODE} + " New SvcCd# " + {VW_RPT_MOVEVALIDATION.SERVICECODE} FM

Hi FM, For 1st try this, = IIf ( IsNothing(Fields!OWNER_CONTACTNAME.Value), Fields!OWNER_COMPANYNAME.Value, Ltrim(Rtrim(Fields!OWNER_CONTACTNAME.Value)) & ", " & Ltrim(Rtrim(Fields!OWNER_COMPANYNAME.Value)) ) Thanks KumarKG, MCTS

Hi FM, For 3rd try this, = IIf ( IsNothing(Fields!OLDSERVICECODE.Value) AND NOT IsNothing(Fields!SERVICECODE.Value), "New SvcCd# " + Fields!SERVICECODE.Value, IIf( IsNothing(Fields!SERVICECODE.Value) AND NOT IsNothing(Fields!OLDSERVICECODE.Value), "Old SvcCd# " + Fields!OLDSERVICECODE.Value, "Old SvcCd# " + Fields!OLDSERVICECODE.Value + " New SvcCd# " + Fields!SERVICECODE.Value ) ) Thanks KumarKG, MCTS

Hi FM, Any progress on this thread? Thanks KumarKG, MCTS

Sorry i was sick and away but yes it worked thank you very muchFM