if isnull({VW_RPT_INV_STANDARD_FORMAT.SERVICECODE}) then {VW_RPT_INV_STANDARD_FORMAT.MATERIALDESCRIPTION} else {VW_RPT_INV_STANDARD_FORMAT.MATERIALDESCRIPTION} + " SvcCd: " + {VW_RPT_INV_STANDARD_FORMAT.SERVICECODE} FM

=iif(isnothing(Fields!SERVICECODE.Value), Fields!MATERIALDESCRIPTION.Value, Fields!MATERIALDESCRIPTION.Value & " SvcCd: " & Fields!SERVICECODE.Value)

Thanks that works... Can you help me out with this = IIf ( IsNothing(Fields!AUTHNUMBER.Value) OR (Fields!AUTHNUMBER.Value = 0), "", CStr(Fields!AUTHNUMBER.Value) ) + " " + IIf ( IsNothing(Fields!MATERIALCOLORBAND.Value), "", CStr(Fields!MATERIALCOLORBAND.Value) ) + " " + IIf ( IsNothing(Fields!MATERIALTYPE.Value), "", CStr(Fields!MATERIALTYPE.Value) ) + " " When i run this expression i get an "#error" in my textboxFM

try replacing the + operator with &: = IIf ( IsNothing(Fields!AUTHNUMBER.Value) OR (Fields!AUTHNUMBER.Value = 0), "", CStr(Fields!AUTHNUMBER.Value) ) & " " & IIf ( IsNothing(Fields!MATERIALCOLORBAND.Value), "", CStr(Fields!MATERIALCOLORBAND.Value) ) & " " & IIf ( IsNothing(Fields!MATERIALTYPE.Value), "", CStr(Fields!MATERIALTYPE.Value) ) & " "

How bout this one? The last one works if isnull({VW_RPT_INV_STANDARD_FORMAT.SERVICECODE}) then {@GroupPrint} else {@GroupPrint} + " SvcCd: " + {VW_RPT_INV_STANDARD_FORMAT.SERVICECODE} FM

Hi FM, What is {@GroupPrint} ? Can you tell us more clearly? Or are you looking for something like this, = IIf ( IsNothing(Fields!SERVICECODE.Value), "@GroupPrint", "@GroupPrint" & " SvcCd: " & Fields!SERVICECODE.Value ) Thanks KumarKG, MCTS

Hi FM, Please complete the thread if your issue has been resolved, here is a ref link:- http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/09d76948-75f8-403d-af19-b1f1c26bd8ee/#0d447204-a646-47b9-a18a-b1570baf5a40 Thanks KumarKG, MCTS