BUILDING CUSTOM REPORT PROBLEM

[ivanov]

My report is structured as such: I have a Report Header, A second Report Header, where I want the Report Footer sum total showing. And a Detail of prices.
My problem is this, how can I show the sum total from the Report Footer to show on the second Report Header?
NOTE: The reason why I have a second Report Header is because I have a unique custom text required only at the bottom of the first page. If I had put the Report Header as a Report Footer and used "Suppress pagenumber > 1" the following pages would have the bottom half of the page suppressed and the Detail amounts would only run 5-6 item lines per page. What's with that?
Does anybody have any suggestions.

 

[ravula2000]

If you can calculate the sum and can keep in the result set column, you can solve this. Place the sum column on the report header b. If you dont have groups all the records will have the same value in that sum column. If you are using any groups you can calculate group sum and can put in the sum column.