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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Put the formula on the canvas
right click
subtotal
right click
subtotal
Actually it is
Right click the field
CLick INSERT --> SUMMARY
Set it up as a SUM
mlmcc
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
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
ASKER