rave reports - sum problem

[neotropic]

Hi,

what I want to do is to print the sum of all account balances of all customers from one company. I use a CalcText to sum these fields..

Although, i want to sum not only the page, but the entire databand.

It,s ok when all fields can be print on one page, but when there are to many fields, the sum is made on the page and not the entire databand... Anybody has a clue?

john

 

[coffytan]

I'm using another kind of report but hope that this can help you up.

if you calculation field was in the report builder.
Did you report have the grouping for the Company?? If yes, you need to make sure the calculate field was in the group summary band.

Best regards,

Coffy Tan

 

[neotropic]

Hi Coffy Tan,

ya I did it and it works fine thanx. Although, I want the calculate field to appear at the bottom of each page.

That is a problem beacause if a group has to be print on two page for example, the right result will appear only on the second page.

I tried to use a PIVar and it works fine, but only for the first group. The PIVar seems to be available for only one group??!

I tried with a parameter but the result on the first page wasn't correct (the second was although).

Anybody?

Cheers,

julien