Getting the Subtotal

• giontech

  Ten Centuries

  Points: 1094

  More actions

  April 25, 2008 at 5:51 am

  #186965

  How can something like this be done in reporting services? I'm having trouble to get the totals, because if I do Sum(Fields!Yes.Value) + Sum(Fields!No.Value) it will just give me the overall total (133).

  Please help guys. I tried with the matrix but it always breaks or just doesn't want to give me the subtotals.

  

• Prasad Bhogadi

  SSCrazy Eights

  Points: 9235

  More actions

  April 25, 2008 at 11:35 am

  #807337

  giontech (4/25/2008)

  ---

  How can something like this be done in reporting services? I'm having trouble to get the totals, because if I do Sum(Fields!Yes.Value) + Sum(Fields!No.Value) it will just give me the overall total (133).

  Please help guys. I tried with the matrix but it always breaks or just doesn't want to give me the subtotals.

  

  The best way to do is using a matrix, I am not sure what do you mean by it always break. You just need to use a matrix and right click inside group and select sub total. It will automatically insert the sub-total group item and does all the logic required for you to display the totals.

  Prasad Bhogadi
  www.inforaise.com