How can a line within the TABLE control be added to show the "Grand Total" of a certain field at the DataSetReport level. For exmaple: = "Grand Total : " & format(SUM(Fields!DailySales.Value,"DataSetReport"), "###,###,##0") And there is no real/valid group available highest than the GroupMonth. I have tried to put the "Grand-Total" line at the same group level as the GroupMonth, it displays the correct amount. But then it re-displays the same number again when the GroupMonth change. Like to see the "Grand-Total" line only 1 time at the Group Header. to display the grand-total. I know about the Group. But, let say for instance, there is a GroupMonth of which the Monthly-total can be calculated as format(SUM(Fields!DailySales.Value,"GroupMonth"), "###,###,##0")

Hi, you can display the grand total at the detail level of a table report. What you can do is add the details row in the table and add the expression below "Grand Total : " & format(SUM(Fields!DailySales.Value,"DataSetReport"), "###,###,##0") Please mark as answer if this post helps Thanks, Shobhit

Hi, As you posted, we can use the expression like =Sum(Fields!DailySales.Value,"DataSetName") calculate the grand total of a certain field at the dataset level. However, I am still confused where you need to show the grand total in the table. If you need the grand total only be displayed once in the table header/footer, please right click the handle of the detail row and enable Table Header/Footer. Then, specify the expression in the table header/footer row. If I have something misunderstood, please point out. Thanks, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.