Link to home
Start Free TrialLog in
Avatar of wilko100
wilko100

asked on

Crystal reports find total number of records

Im new to Crystal reports. I have a report and want to find a total number of records that record fields equals to the text "On Time". How is that done is Crystal 8.5?
ASKER CERTIFIED SOLUTION
Avatar of JayConverse
JayConverse
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of wilko100
wilko100

ASKER

Got first bit going. How would i sum it?
Put the formula on the canvas
right click
subtotal
Avatar of Mike McCracken
Actually it is

Right click the field
CLick INSERT --> SUMMARY
Set it up as a SUM

mlmcc
You can also use a Running Total to get this.

Create a NEW running total
Choose a name - COuntOnTime
Choose the OnTime field
Set the type to COUNT
Evaluate - use formula
   {myfield} = "On Time"
Reset - Never

mlmcc