Subtotal needs to display at the end of each page.

Hi,
I have a requirment like:-
I have to display subtotal (sum of amount) at the end of each page,for some organization unit.
but the problem i am facing is:=e.g.
I have to dispaly three columns department number,employees and salary.
if for organization unit=10,
there exist ten departments and the hole data for that org. unit is going beyond one page, then at the end of first page for that organization unit subtotal should be displayed.
My logic is:-
I have applied format trigger on subtotal,which will dispaly subtotal filed after every 10 department number (This is like hardcoded logic)work fine for most of the org unit.
but the problem comes when number of employees for some department increases to the level that count of department=10 comes at next page so subtotal will be displayed in between the second page.
Can anyone suggest me the logic for same...it's really very urgent.

I may not give you a complete information, but I can make some points clear
like I said I have to display 3 columns Department ,employees and salary. Deparment is a master column employees and salary is a details records(in a repeating frame).According to my logic I am counting no of departments (not countinfg any of the detail records) and after perticular no of rows I am dislaying Subtotal using format trigger, but the mistake is I am doing is I am not considering employees and salary column which may increase to a extend that my condition satisfies at the next page and subtotal dispalys in between the next page.    Start Free Trial