Post reply

Getting the Subtotal

  • 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.

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply