Hi, I have a dataset query result is like the following, the selection of this query cannot be changed due to other fields are using same one. We are using SSRS 2008r2, and on the report, after adding row group "category", the result is like the following snapshot, the amount is supposed to be a total grouped by category, in this case, it should show 261 instead of 0,130.5,130.5. And we cannot adding sum(amount) inside queries, because it's used other tables. Is there any way to adding total in report only grouped by category? Appreciate for the help.

Hi There It is very simple if category is your only group and next levels detail then Please right click on that details group and add total after and just add the expression sum(amount) Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful For your reference similar thread I have answered the question http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/0447e3f4-e1a5-4fed-81f4-4f2982498038

Hi Syed Qazafi Anjum, Thank you for posting. I right click on that details group and add total after , the column on the right side of Category breaks into two rows, I select Fields!amount.value in first row, and automatically sum(Fields!amount.value) becomes second row. And report looks like this, it's really good I got 261 right now, but how do I remove 0,130.5,130,5?

Hi There Do you not need to show these details values(130.5,130.5,0)? if that is the case then you just delete the detail row and it will be done If you have any question please let me know. Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

Thank you. It works well.