Group Total Variables

[fancyface2]

Using Crystal 11 - Does anyone know how to count the distinct number of records for a particular group and only display one row per group in the footer using variable formulas. For example:
Group #A
1
1
Group #B
2
2
2
3


Should return:
Variable Count
Group A 1
Group B 2

Any help would be greatly appreciated. Thanks

 

[lbass]

If you insert a group, then all you have to do is insert a distinctcount on the detail field at the group level. Then drag the groupname into the footer next to the summary, and suppress the detail and group header sections.

-LB

 

[fancyface2]

Thanks. I am also trying to only count those records that meet the following criteria: anyone whose sum of giving <990. So I need a running total of those records in that group however, the rows are not unique ie. as in above in Group A record one is the same as record two but I only want to count it once. A running total does not allow me to pick up the formula that states (amt,id) < 990. Hopefully I am explaining this correctly.

Thanks.

 

[lbass]

Sure it does. Insert a running total that does a distinct count of the appropriate detail field, evaluate using a formula:

sum({table.amt},{table.ID})<990

Reset on change of ID group.

-LB