RDLC report : Page Wise total (repeat) on last page

[jazzyb]

I am using rdlc reprot in VB (Visual Studio) with MS Sql Express. I want the output as given below :

SrNo.      Amount
1          100
2          100
3          100
4          100
Group Total = 400
5          200
6          200
Page1 Total = 800
***************************PAGE1 END HERE****************
7.         200
8.         200
9          200
Group2 Total=1000
Page2 Total = 600
****************************PAGE 2 END HERE*****************

Page1 Total = 800
Page 2 Total =600

Grand Total = 1400
******************************LAST PAGE END HERE**************

I am able to get all output except Page1 Total and Page2 Total on last page.

For Group Total I have used Sum function of rdlc with Table1_Group2 Scope.

For Grand Total I have used Sum function of rdlc with dataset scope.

For Page Wise total on each page I have used Reprot footer text box with code "=Sum(ReportItems!amt.Value)".

My problem is : How to get each page wise total on last page again(repeat).

Thanks