Sum .two counts

• bmx123

  SSC Rookie

  Points: 34

  More actions

  November 22, 2004 at 2:54 pm

  #109620

  Hi,

  I'm using reporting services. I have two tables. Each table has a column that has been counted like count(Fields!Account_name.value) Now i want to display the sum of two counts at the bottom of the two tables. And I'm using two Datasets in this report. How do i do that?Any Help?

• kmlakov

  SSC Journeyman

  Points: 92

  More actions

  November 23, 2004 at 7:15 am

  #531211

  this would go into value field of textbox

  = first(Fields!field1.Value, "dataset1") + first(Fields!field2.Value, "dataset2")

  you could also look at the sum function