none
How to enable Add Total option in Tablix

    Question

  • I had a problem of couting sum of grouped rows in a tablix. I posted it on stackoverflow. There I found the detailed answer by a user. But the problem is now, he is asking me to add "Add Total" in one cell of my tablix. Whereas I find no option of adding Add Total on every cell. In fact it is disabled on each cell except the cell that is coming under a group.

    The person is using Italian IDE (Visual Studio) whereas my IDE is in english. Is there any difference between these two?

    Please see the detailed post and reply if there is any solution.

    I'll be thankful.

    Here you can find the answer about which I'm talking:

    http://stackoverflow.com/questions/6252561/ssrs-sum-in-table-group

    Monday, June 13, 2011 7:45 AM

Answers

  • Hi Developer051,

    Thanks for your question. Based on your description on the two forums, I understand that there are two columns in your database table, for example: AgeName and Agecounts. You want to get the total number of Agecounts in each AgeName and grouped the total number of Agecounts on the corresponding AgeName, right? If I misunderstand your question, please let me know.

    Actually, because the matrix has the group and sum function by default, so it will be easier to achieve the requirement if you choice the tablix of a matrix instead of a table, please follow the below detail steps to bind the data in a matrix,

    Supposing the originally database structure and data like below,

     

    1. Click the Design tab, in the Toolbox window, drag the Matrix control onto the design surface, point to the textbox on the second row of the first column, click the Field List icon, select AgeName.

    2. Point to the textbox on the second row of the second column, click the Field List icon, select Agecounts.

    Please preview your report, you will get the effect just like this,

     

    For more information about Adding a Matrix (Reporting Services), please see: http://msdn.microsoft.com/en-us/library/ms157334.aspx.

    If you have any other question, please feel free to let me know. 

    Thanks,
    Sharp Wang


    Best Regards. Sharp Wang
    • Marked as answer by Developer051 Tuesday, June 14, 2011 5:55 AM
    Tuesday, June 14, 2011 3:21 AM
    Moderator

All replies

  • HI Developer,

    PLease check have you put some expression on the cell value..Add total is disable if there is a expression or format string for value of cell.

    Just undo the expression and right click on the field you get it enabled and after adding total put your expression on the field agiain.

     

    hope it will help.


    -------------------------------------------------------------------------------- Please mark my post as an answer if I helped you to resolve the issue or vote up if I helped you.Thanks. Regards and good Wishes, Maqbool.
    Monday, June 13, 2011 7:57 AM
  • hello,

    Thanks for reply, but if there is no expression in cell, Add Total is still disabled. Is there any other reason?

     

    Monday, June 13, 2011 9:09 AM
  • Hi Developer051,

    Thanks for your question. Based on your description on the two forums, I understand that there are two columns in your database table, for example: AgeName and Agecounts. You want to get the total number of Agecounts in each AgeName and grouped the total number of Agecounts on the corresponding AgeName, right? If I misunderstand your question, please let me know.

    Actually, because the matrix has the group and sum function by default, so it will be easier to achieve the requirement if you choice the tablix of a matrix instead of a table, please follow the below detail steps to bind the data in a matrix,

    Supposing the originally database structure and data like below,

     

    1. Click the Design tab, in the Toolbox window, drag the Matrix control onto the design surface, point to the textbox on the second row of the first column, click the Field List icon, select AgeName.

    2. Point to the textbox on the second row of the second column, click the Field List icon, select Agecounts.

    Please preview your report, you will get the effect just like this,

     

    For more information about Adding a Matrix (Reporting Services), please see: http://msdn.microsoft.com/en-us/library/ms157334.aspx.

    If you have any other question, please feel free to let me know. 

    Thanks,
    Sharp Wang


    Best Regards. Sharp Wang
    • Marked as answer by Developer051 Tuesday, June 14, 2011 5:55 AM
    Tuesday, June 14, 2011 3:21 AM
    Moderator
  • You solved my problem Sharp Wang. Thank you SO MUCH ...

    I just added a matrix and followed your instructions. Then the only thing I did is to write the expression as

    =Sum(Fields!AgeTotal.Value)

     


    in second row, second column. It worked great. Thank you so much once again.

    Best regards,

    Developer051

    Tuesday, June 14, 2011 5:55 AM