Hey all,

I'm trying to create a 'summary report' in crystal reports. I have a field called 'Transaction Status' which can have 1 of 4 values: Approved, Declined, Failed, or Unsupported. How would I, for example, count only the total number of approved transactions (rather than counting the total number of transactions). In the report I want to count these values and display them in the form:

Number of Approved Transactions: xxxx
Number of Failed Transactions: xxxx
...etc.

I'd like to do this without using a cross-tab. So, is their some sort of formula that could accomplish the same thing for me.

Thanks