[rsCompilerErrorInExpression] error

• tt-615680

  SSCertifiable

  Points: 7835

  More actions

  March 6, 2012 at 9:15 am

  #252708

  Hi All,

  I'm trying to add two field together using the following expression in Reporting Services:

  =(Sum(Fields!tranAmount.Value,

  "DataSet1") +

  =(Sum(Fields!Cost.Value,

  "DataSet1")

  but I get the following error message: Error 3 [rsCompilerErrorInExpression] The Value expression for the textrun ‘Textbox16.Paragraphs[0].TextRuns[0]’ contains an error: [BC30198] ')' expected. Would someone let me know what I'm doing wrong please? Thank you!

• Possinator

  Hall of Fame

  Points: 3422

  More actions

  March 6, 2012 at 4:55 pm

  #1455674

  =(Sum(Fields!FEE_transactionAmount.Value,

  "DataSet1") +

  =(Sum(Fields!FEE_OptionCost.Value,

  "DataSet1")

  Looks like you copied the 2nd half of the formula from another field. Remove the 2nd = sign.

  =(Sum(Fields!FEE_transactionAmount.Value, "DataSet1") + (Sum(Fields!FEE_OptionCost.Value, "DataSet1")

  [font="Courier New"]Looking for a Deadlock Victim Support Group..[/font]