This is a short and to the point Crystal Reports post to assist anyone trying to count the number of Groups in a report. If you are using Crystal Reports you will know that the Summary does not work on Groups. We hope you find the following useful!
Crystal Report Group Count
To count the number of Crystal Report group entries in a report, rather than the entries within a Group, use the following process:
1) Create a formula @GroupCountReset and place this formula in the page header and make it suppressed (hidden)
whileprintingrecords;
numbervar i:=0;
2) Create another formula @GroupCountEval place this in the group header where you want to count the entries and suppress if required
whileprintingrecords;
numbervar i:= i+1;
3) Create another formula @GroupCountDisplay and place this in report footer. Don’t suppress this one! You need to see it!
whileprintingrecords;
numbervar i;
You should now have a count of Group entries.
Useful information for Crystal Reports and Crystal Reports for SAP Business One.
