help : can't get last record on page

[yunan]

hi,
i am new in crystal report. please help me find solution.
i want to design report like this. on page one have balance count every record and when its out of page (it means go to page 2) , page 2 show the 'last balance' from page one and page 3,4,5 same to do.
i have data from sql server that automatically count balance's field , on report it just shown and not executing any formula.
so, what formula i must write to design a report like the picture i attach?

thanks for the help

 

[lbass]

Create a formula to place in the page header:

previous(balance)

This will pick up the balance from the last record on the previous page.

-LB