Having a hard time figuring this out. Relatively new to Crystal, and this is a bit beyond me.

I'm creating a report where I have offenders grouped under the officers that are assigned to them. I have a summary field on each group so I know how many offenders are assigned to each officer.

I need to figure out the LOWEST number of offenders that are assigned to any one officer, as well as the HIGHEST.

In other words, I need to kick out: "Lowest number of offenders assigned to any one officer is ## and the highest number of offenders assigned to any one officer is ##"

I took my summary totals, and tried to create a formula that did a MINIMUM or MAXIMUM on the summary field but I get an error about the field not being able to be summarized.

Using CR 2008, but will need to do the same thing in 8.5 so I can roll out the report to various organizations that need it.

Edited by mproper - 27 Oct 2011 at 8:19am