Count number of groups?

[patti2]

Using CR 8.5, how can I count the number of groups? Group is by customer, group selection is count ({detail field}) > 1 and I want to know how many customers fit the criteria.

Thanks in advance.

 

[dgillz]

The number of groups is easily determined with the following formula in your report footer:

Maximum(GroupNumber)


Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[patti2]

Thanks, dgillz,
I knew there had to be a simple solution.

 

[lbass]

I don't think you can use the maximum function with groupnumber. Try going to insert->special field->groupnumber and placing groupnumber directly into the report footer. Since groupnumber is a running total of groups, it will ignore the non-group selected groups when counting.

-LB

 

[MJRBIM]

Couldn't you just use a Distinct Count of whatever field you are grouping on...?

 

[synapsevampire]

MJRBIM: Yep, and it would be available anywhere in the report.

distinctcount({table.field})

-k

 

[lbass]

Nope, because distinctcount will pick up the non-group selected groups.

-LB

 

[synapsevampire]

LB: Good point, if the grouping isn't performed on the server it won't, and Crystal won't pass the distinctcount, but oddly still counts items which are excluded by the group selection.

I tend to always think in SQL terms, not Crystal Grouping.

-k

 

[patti2]

Thanks, all for your input. I find the exchange to be quite helpful. I get frustrated when what works in one software doesn't in the next. Unfortunately, I don't think my brand of multi-lingualism will help me on a world-wide vacation!

FYI, maximum(groupnumber) did not work, however lbass' solution of placing groupnumber in report footer did.

-p