= "(" + Fields!SOWO.Value + ")" + Fields!WORKORDERNUMBER + "-" + + RIGHT("0" + CStr(Fields!WOLINENUMBER.Value), 2) Desired out put : (S) 1562851-01 I wrote the above expression to get the desired result = (S) 1562851-01 but when i run the report i get an error message see below ::: 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.FeildFM

Try using & instead of +. Are you sure that this expression points to textbox22 ? I'm just curious, did you copy paste the error or typed it on your own? because there is some typo in ReportobjectModel.Feild SqlUser2011

SQLUSER2011, I get the same error.FM

I double checked if its the textbox22 and yes its pointing to textbox 22 and i typed it not copied n pasted the error.FM

= "(" + Fields!SOWO.Value + ")" + Fields!WORKORDERNUMBER + "-" + + RIGHT("0" + CStr(Fields!WOLINENUMBER.Value), 2) take one + off before RIGHT, there should be only one +, try the following, it worked for me.. = "(" + Fields!SOWO.Value + ")" + Fields!WORKORDERNUMBER + "-" + RIGHT("0" + CStr(Fields!WOLINENUMBER.Value), 2) Cheers!SqlUser2011

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

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