Dynamic Page number reset in FR report

Hi Gurus,

I have a requirement to rest the page number in report footer based on change in page dimension value (Company in this case). To explain, client wants to run Balance sheet designed in FRS using value "all company values in" POV. This populates 80 odd companies in page axis and the report contains the balance sheet for each company. the page number in derived in footer using text function page(). However, this gives continuous page numbers. e.g. 1 to 500. The requirement is to have a page number reset for each company, say, if balance sheet for company 101 is