Dear Eric,
You use the knowledge gained from SV's (* from me) helpful post to you, to extrapolate that you need to again use variables.
Also, I recommend that you change your grouping as the Close Date field in that table is a calculated field converted to a varchar (text field). If you do not change your grouping to Close Date & Time ordered by Day, then my formula below will fail with an error on the field name.
Here is an example:
//Placement Group Footer.
WhilePrintingRecords;
numbervar min;
numbervar MyCount;
min := If mycount = 1 then
Count({Incident.Incident #}, {Incident.Close Date & Time}, "weekly")
else if
mycount > 1
then if min < Count({Incident.Incident #}, {Incident.Close Date & Time}, "weekly")
then min else Count({Incident.Incident #}, {Incident.Close Date & Time}, "weekly");
min
//Begin Display Min
//placement report footer
whileprintingrecords;
numbervar min;
min
To get the MAX, you would create a new set of two formula (Group Footer and Report Footer) using a new variable named Max perhaps and check to see if Max is > than your count formula.
regards,
ro
Rosemary Lieberman
rosemary-at-microflo.com,
Microflo provides expert consulting on MagicTSD and Crystal Reports.
You will get answers more quickly if you read this before posting: faq149-3762