Crystal reports formula with group footer

[shapre]

Hi,
I have a scenario where there are two groups
Private and public groups which have multiple records/clients in them.
I then summerize the groups with a formula based on a condition to detect the type of client. there are in total 3 levels of grouping where the 3rd level of grouping is of client name (private or public).

Private clients
client 1 100
client 2 100
total: 200
Public client
client 3 200
client 4 100
total:300
Grand total 500
So could you help me understand how I could assign private client's value to a variable and the public client's to another so that I could sum them.

 

[lbass]

Based on your example, you could just insert a summary at the grand total level. So you need to explain why you can't do that.

-LB

 

[Madawc]

If you want the two group totals in the same place, you'd need to do a running total for each. The use of Crystal's automated totals is outlined at FAQ767-6524.

It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options. In this case, it probably makes no difference.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP