>I want a page total to appear only in the last page of a report.
>How do i configure the page footer such that the page total does not appear on any other page except the last

In the Report Designer, select Report>Title/Summary and create a Summary band.

Anything you put in the Summary band prints at the end of the report.