Transfooter & Transheader in Nav R2 report

1.We add this TextBox in top of the Body.

Value =True
Name =NewPage
Visibility Hidden: “True”
Color: “Red”
-------------------------------------------------------
2.We add this TextBox in Bottom of the Body.

Value =True
Name =LastPageControl
Visibility Hidden: “True”
Color: “Red”
-------------------------------------------------------
3. Add TextBox to the body of the Table.

Name=Subtotals1
Value="Transfooter subtotal  " &  Format( RunningValue(Fields!Customer__Debit_Amount_.Value, Sum, "MainTable"),"#,##0.00")
Visibility Hidden: “True”
Color: “Red”
-------------------------------------------------------
4. Add TextBox to the body of the Table.

Name=Subtotals2
Value="Transheader subtotal  " & Format(RunningValue(Fields!Customer__Debit_Amount_.Value, Sum, "MainTable") - Fields!Customer__Debit_Amount_.Value,"#,##0.00")
Visibility Hidden: “True”
Color: “Red”
-------------------------------------------------------
5. Add TextBox to the body of the Table.

Name=SubCount
Value=RunningValue(Fields!Customer__No__.Value, Count, "MainTable")
Visibility Hidden: “True”
Color: “Red”
-------------------------------------------------------
6. Table
Name=MainTable
-------------------------------------------------------
7. Add TextBox to the Page Header.

Value=(First(ReportItems!Subtotals2.Value))
Visibility=ReportItems!NewPage.Value

PrintOnFirstPage=False
PrintOnLastPage=True
-------------------------------------------------------
8. Add TextBox to the Page Footer.

Value=(Last(ReportItems!Subtotals1.Value))
Visibility=ReportItems!LastPageControl.Value

PrintOnFirstPage=True
PrintOnLastPage=True