Summing a column at the top of a page?

rbuser

Hi All,

I wan't to put the sum of a column at the top of the page before the
detail. This sum is the total sum prior to the current page. When I put
a DBCalc it also sums the first entry of the current page. Any ideas or
work-arounds?

I also couldn't put a page total. Is there a way to reset the DBCalc
with page-break?



thanks

Bora Aydemir

nicocizik

Bora,

Try setting the DBCalc for the sum to "Look Ahead" by changing the LookAhead
property to true. You can also set a page break reset by creating a
TppVariable and adjusting the timing to reset on the page break. Right
click over the variable to get the timing dialog.

--

rbuser

Hi Nico

The 'look Ahead' property didn't work for me since it calculates the sum
including that page. I needed a total that shows the same total at the
footer of the prior page. I managed to do that with two variables and
your tip on timing. Just wanted to ask if calculation based on another
calculation is reliable? (I set the Calc order of the band)

thanks

Bora

nicocizik

Hi Bora,

Sorry for the misunderstanding. I'm glad you found a solution. To answer
your question, yes a calculation based on another calculation is reliable as
long as the timing is correct and the calc order is set for the variables in
each band.

--