Sum Running Totals

[giggles7840]

CRXISP2
XP Pro

I have two groups in my report. In group header 2 I am displaying my records and I have a running total which counts a specific type of record that is displayed. I need to show the sum of that running total in Group Footer 1.

This is what I want to see:
GH2 00 2 weeks 1
GH2 10 Notice 0
GH2 10 Notice 0
GH2 00 2 weeks 1
GF1 2

Any ideas?

 

[giggles7840]

I also created a variable that seems to be counting the way I need it to:
numbervar cnt := 0;
if {@Milestone code-desc} startswith '00' then
cnt + 1;

However, it is not summing properly. It is looking at the detail records and I only want it to count the group header records.

 

[musini]

In the running total formula you are using, are u doing the evaluate only on change of group. If not try that I think that should work.

M

 

[lbass]

Is this the running total you were referring to?

Your formulas should be:

//{@reset} to be placed in GH1:
whileprintingrecords;
numbervar cnt;
if not inrepeatedgroupheader then
cnt := 0;

//{@cnt} to be placed in GH2:
whileprintingrecords;
numbervar cnt;
if {@Milestone code-desc} startswith '00' then
cnt := cnt + 1;

//{@display} to be placed in GF1:
whileprintingrecords;
numbervar cnt;

-LB