Hi, I have a report in which first column is CITY and consists of 5 data (5 cities),all other columns are grouped w.r.t CITY, i.e in one city there can be 100s of other column data, last column of report is INCOME. If I right click on [INCOME] field and select ADD TOTAL then it gives citywise total, but I limited only 10 records per page and pagebreak option is selected at end of the CITY group. When perform the same operation now it gives pagewise sum not the groupwise, please rectify my approach if I am wrong else suggest the solution.

Hi, I would suggest you use subreport to do the summation. Check http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/b3ea0253-bb5a-463d-82e8-4e9d1d9eed3a with the same topic, there i have give a detailed solution. thanks, Jerry