Total of calculated fields based in another calculated field

• syedathariqbal

  Hall of Fame

  Points: 3175

  More actions

  June 15, 2011 at 8:14 am

  #252013

  I am encountering an issue in one of my report, googled a little on the same and got below query posted by someone.

  http://www.sqldev.org/sql-server-reporting-services/total-of-calculated-fields-based-in-another-calculated-field-32880.shtml

  I am having exactly same issue as above, however in the above link solution is not provided. I am using SSRS 2008.

  Kindly help !!!!

  Thanks in advance.

  Athar Iqbal

• veeren4urs

  SSCrazy

  Points: 2763

  More actions

  June 22, 2011 at 10:27 am

  #1342575

  My suggetion is give a name for the textbox something like "Cal1" and other calculated feild as "Cal2"

  Use the below expression to get the values.

  =ReportItems!Cal1.Vaule

  =ReportItems!Cal2.value

  Thanks & Regards,
  Veeren.
  Ignore this if you feel i am Wrong. 😉