Sum of each row in Table Reports - SSRS 2005

• Sakthivel Chidambaram

  SSCertifiable

  Points: 5531

  More actions

  February 23, 2009 at 11:38 pm

  #218689

  Hi Friends,

  I'm designing a report, output of sql already contains grouped data. When the table is displayed in report, I want the sum of all column for each row appear as last row. How to do that?

  SQL output[/b]

  Name Marks1 Marks2 Total

  Sakthi 100 100 ??

  Steve 10 20 ??

  Brian 3 5 ??

  I want to dynamically get the value for Total Column by adding Marks1 and Marks2 for each row in SSRS.

  Regards,
  Sakthi
  My Blog -> http://www.sqlserverdba.co.cc

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  February 24, 2009 at 7:26 am

  #949343

  Assuming you have a fixed # of columns you would just put in an expression that adds the values of all the prior columns:

  =Fields!Marks1.Value + Fields!Marks2.Value

  I don't know a way to do it beyond that.

  You could also pass out the total from your query.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• Sakthivel Chidambaram

  SSCertifiable

  Points: 5531

  More actions

  February 25, 2009 at 5:37 am

  #949894

  Thanks Jack... It works!

  Regards,
  Sakthi
  My Blog -> http://www.sqlserverdba.co.cc