Can you help me with this kumar (if (isnull({VW_RPT_INV_STANDARD_FORMAT.AUTHNUMBER}) or {?ShowAuthNumber} = 0) then "" else ({VW_RPT_INV_STANDARD_FORMAT.AUTHNUMBER} + " ")) + (if isnull({VW_RPT_INV_STANDARD_FORMAT.MATERIALCOLORBAND}) then "" else ({VW_RPT_INV_STANDARD_FORMAT.MATERIALCOLORBAND} + " ")) + (if isnull({VW_RPT_INV_STANDARD_FORMAT.MATERIALTYPE}) then "" else ({VW_RPT_INV_STANDARD_FORMAT.MATERIALTYPE} + " "))FM

= "(" + (Fields!SOWO.Value ) + ")" + (Fields!WORKORDERNUMBER) + "-" + RIGHT("0" + CStr(Fields!WOLINENUMBER.Value), 2) When i run the above expression i get an error message The Value expression for the textbox22.Paragraphs[0].TextRuns[0]' Contains an error: [BC30452] OPERATOR '+' is not defined for types 'object' and 'Microsoft.ReportingServices.ReportProcessing.ReportobjectModel.Feild I have tried every possibe way , did research all over and yet i still get the error... Any ideas????????? FM

try this out, = IIf ( IsNothing(Fields!AUTHNUMBER.Value) OR (Fields!ShowAuthNumber.Value = 0), "", CStr(Fields!AUTHNUMBER.Value) ) + " " + IIf ( IsNothing(Fields!MATERIALCOLORBAND.Value), "", CStr(Fields!MATERIALCOLORBAND.Value) ) + " " + IIf ( IsNothing(Fields!MATERIALTYPE.Value), "", CStr(Fields!MATERIALTYPE.Value) ) + " " Thanks KumarKG, MCTS

Hi FM, try this, = "(" + (Fields!SOWO.Value ) + ")" + (Fields!WORKORDERNUMBER) + "-0" + RIGHT(CStr(Fields!WOLINENUMBER.Value), 2) OR = "(" + (Fields!SOWO.Value ) + ")" + (Fields!WORKORDERNUMBER) + "-" + "0" + RIGHT(CStr(Fields!WOLINENUMBER.Value), 2) Please let us know your feedback. Thanks KumarKG, MCTS

Dont you have to say Fields!WORKORDERNUMBER.Value ?

try this, too = "(" + CStr(Fields!SOWO.Value) + ")" + CStr(Fields!WORKORDERNUMBER) + "-" + "0" + RIGHT(CStr(Fields!WOLINENUMBER.Value), 2) KumarKG, MCTS

I can run the report with this expression but iget an #error in the textbox of this expressionFM

Thanks Kumar this works i actually needed to use the expression this way = "(" + CStr(Fields!SOWO.Value) + ")" + CStr(Fields!WORKORDERNUMBER.Value) + "-" + "0" + RIGHT(CStr(Fields!WOLINENUMBER.Value), 2)FM