• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 688
  • Last Modified:

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?
0
wilko100
Asked:
wilko100
  • 2
  • 2
1 Solution
 
JayConverseCommented:
One simple way is to make a formula that says:

if {myfield} = "On Time" then 1 else 0

and sum it.
0
 
wilko100Author Commented:
Got first bit going. How would i sum it?
0
 
JayConverseCommented:
Put the formula on the canvas
right click
subtotal
0
 
mlmccCommented:
Actually it is

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

mlmcc
0
 
mlmccCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now