I will admit that my Crystal Report skills are okay, so I will say what I want to do rather than try to explain how I am doing it.

I am trying to measure the number of tickets created by my group that is closed on the same day it was created.  This is a measure of my team's success.  I have the following fields.

To make things more fun, this is a Notes Backend so I have to make all of the condition changes.

Parameter Field for a Date Range that is entered on the Database.
The Date when the Ticket was created
The Date when the Ticket was closed
A unique serial number field that is automatically created
Who Closed the Request, if it was closed.

I want my report to look like this


Tech 1      xxx
Tech 2     xxx
Tech 3     xxxx
.....
Total Closed on same day     Sum of all xxxx's
Total Opened in the Range   yyyyy
Percentage of same day closure    xxxxx/yyyyy  %

Groups are not working like I want it to be, but I will try again.  I have not tried Running Totals yet.

Any advice?

I talk about this in Chapter 3 of my Encyclopedia book. When using groups, the grand total will still list everything that gets excluded. So you can suppress the data you don't want to show and it is still part of the grand total.

You can find out more about my books at Amazon.com or reading the Crystal Reports eBooks online.