Age old problem - trying to summarise at a weird evaluation point 1

[eo]

Hi

CR10; SQL

I have been given the task to add a total to a field, which is the result of summaries in GF3 (based of currency values in the Details band), etc etc, in GF2. So my evaluation timing is all wrong. Someone suggested Resent formulas, but I cannot remember how they work. I can send the whole formula process if thgat will help, as I am not even sure if reset formulas are the solution.

Many thanks in urgent advance!

EO
Hertfordshire, England

 

[lbass]

Are you trying to total summaries in the Group Footer 3 to display at Group Footer #2? Is there a reason you can't just insert a summary to display at all group levels? How about some sample data?

If you can't use an inserted summary, then use a variable:

//{@reset} to be placed in the Group #2 Header:
whileprintingrecords;
numbervar addsummary := 0;

//{@accum} to be placed in the GF#3 footer:
whileprintingrecords;
numbervar addsummary := addsummary + {@yoursummary};

//{@displ} to be placed in the GF#2 Footer:
whileprintingrecords;
numbervar addsummary;

-LB

 

[eo]

These formulas was what I was after. They worked fine. Thanks.

EO
Hertfordshire, England