sum field before subquery

rbuser

I have a report that has a few subqueries. one of them has a calc field
that does the sum of its detail values. I also need that exact same
number to appear on the first page of the report.

How can I do this? If i put another dbcalc on the first page it doesnt
add up write it only gets the first row.

I tried a variable that i set equal to the dbcalc but it gets wiped out
on second pass.

Anythign else i can do?

nicocizik

Hi Chris,

When you place the DBCalc component on the first page be sure you have the
LookAhead property set to True. If you are using Subreports, you will need
to update this value as a TppVariable from the subreport detail band.

--

rbuser

That still doesnt' seem to be working

If have my totals are on one page and half on the next i only get the
half on the current page.

Is there a way to say

IF report.pass = 1

if i could do that my problems would be solved. ( I think )

nicocizik

Hi Chris,

You can use the boolean property TppReport.FirstPass and
TppReport.SecondPass to determine which pass you are currently on.

--