I was wanting to know if anyone knew how to get SUM totals for a section on a page header. I have a static report with 3 sections. Each section starts on a new page is only one page long. Therefore there are 3 sections and 3 pages. I am wanting to put a sum total in the header of each page for each section. I can’t seem to get the totals I need. I can use the IN context and use current page, but that only works for me below the header. I tried putting that context in a cell in the page header and totals are off. Has anyone ever tried this? Any suggestions would be great!
wbuente (BOB member since 2004-06-21)
I believe you cannot do this. The page header is outside the section, so it will not calculate at the section level.
Steve Krandel
(BOB member since 2002-06-25)
You might be able to do something similar with cells set to repeat on every page.
Try putting the calculation in a cell near the top of the page and setting it to repeat. Then put another empty cell slightly below it, remove all the formatting, and set that to also repeat.
Assuming that you have each section starting on a new page, this might work. The blank cell stops the tables from butting right up against the cell with the calculation in. You may have to hide the top-level section header to get things lining up properly between the first and subsequent changes.
Paul Williams
(BOB member since 2002-07-10)