You can go through the reporting services lesson no. 6. This is specific to adding totals and subtotals on different group levels. Below is the link: http://msdn.microsoft.com/en-us/library/ms170712.aspx It'll also lead you to the other topics related to SSRS.Thanks Salman http://muhammadsalmanx.wordpress.com

Hi All, I am new to SSRS 2008 r2,now i working with tabular reports,in that i generate a report like this state city population(in millions) Ap Hyd 6 Vij 3 Vizag 2 Tirupati 1 TN Chennai 7 Coimbator 5 Trichy 4 Delhi North delhi 3 South delhi 5 MH Mumbai 4 Pune 3 KA Bangalore 5 Mysore 2 In this i want Sub total and Grand total,like state city population(in millions) Ap Hyd 6 Vij 3 Vizag 2 Tirupati 1 Sub Total 12 TN Chennai 7 Coimbator 5 Trichy 4 Sub Total 16 Delhi North delhi 3 South delhi 5 Sub Total 8 MH Mumbai 4 Pune 3 Sub Total 7 KA Bangalore 5 Mysore 2 Sub Total 7 Total 48 Can you Please help me Thanks srujtiharam

You can go through the reporting services lesson no. 6. This is specific to adding totals and subtotals on different group levels. Below is the link: http://msdn.microsoft.com/en-us/library/ms170712.aspx It'll also lead you to the other topics related to SSRS.Thanks Salman http://muhammadsalmanx.wordpress.com

Hi Srujtiharam, In your scenario, add totals for each group in the group pane can achieve your requirement. The screenshots are for your reference. You can refer the link that provides by Salman to see how to add a total a group. If you have any questions, please feel free to ask. Regards, Charlie Liao

many Thanks both of you Salman and Charlie Liao i got the solution with your help Thanks srujithram