subtracting value of one textbox from another on my report

• Zeetec

  SSC Eights!

  Points: 844

  More actions

  August 10, 2009 at 8:17 am

  #209435

  Hi,

  I have 2 textboxes on my report for example text1 and text2.

  text1 has an expression: Count(Fields!myfield1.value)

  text2 has an expression: Count(Fields!myfield2.value)

  This works and shows up on my report correctly.

  I created a 3rd textbox and wanted to minus text1 from text 2 like this:-

  Count(ReportItems!text1.value - ReportItems!text2.value)

  When I try and do this in text3 it comes up with the error:-

  report item expressions can only refer to other report items within the same grouping scope or a containing grouping scope

  Not sure how I can get rid of this.

  Thanks.

• thetodaisies

  Ten Centuries

  Points: 1387

  More actions

  August 13, 2009 at 12:22 am

  #1038479

  HI

  why not simply use the expresion in textbox3

  Count(Fields!myfield1.value)-Count(Fields!myfield2.value)

  Thanks