Showing Groups totals in RF

[Steve95]

Hi All

I have 2 groups which I have sumed and then in a formula subtracted by each other and put that value in at group level. Then I have supressed everything else and I need to sum that formula up and show in the RF....How do I do that?

Many Thanks in Advance

Jazz

 

[Madawc]

Is this two specific groups? Then do a running total for the whole report. But give it a selection formula to just add for those two groups.

Right-click on a field and choose Insert to get a choice of Running Total or Summary. Or else use the Field Explorer, the icon that is a grid-like box, to add running totals.

Running totals allow you to do clever things with grouping and formulas. They also accumulate for each line, hence the name. The disadvantage is that they are working out at the same time as the Crystal report formats the line. You cannot test for their values until after the details have been printed. You can show them in the group footer but not the group header, where they will be zero if you are resetting them for each group.

Summary totals are cruder, but are based directly on the data. This means that they can be shown in the header. They can also be used to sort groups, or to suppress them. Suppress a group if it has less than three members, say. They default to 'Grand Total', but also can be for a group.


Madawc Williams (East Anglia, UK)
Windows XP & Crystal 10

 

[Steve95]

they are 2 specific goups....I dont running totals will be appropriate in this instance.....maybe a local or global variable? I am looking into....can you help?

Many Thanks

 

[lbass]

You can use two formulas:

//{@accum} to be placed in the group section:
whileprintingrecords;
numbervar sumcalc := sumcalc + {@yourformula};

//{@display} to be placed in the report footer:
whileprintingrecords;
numbervar sumcalc;

-LB