Crystal Reports: Create a totals amount at end of report


I am looking to find a way to create at the end of my report the total amount of times the certain values are being populated.  Example:  Count the amount of times the word "Completed" is displayed in the "Status" column. I will then use that code to write for all status for that column like "Closed", "Aborted", and " Work In Progress".

Using Crystal 2008
Maliki HassaniAsked:
Who is Participating?
JayConverseConnect With a Mentor Commented:
Make a formula like:

If {myfield} = "Completed" then 1 else 0

and sum that formula
mlmccConnect With a Mentor Commented:
Agree.  Create a formula for each possible value of status.  You can then use the summary functions to get the total count and display it in a summary at the end of the report.

Maliki HassaniAuthor Commented:
So my design changed so I am think this is why it isn't working.  I have created a formula like you stated, and sum up the results using the running Totals Fields.  I am not sure why I am getting a 0 as a return.  You can find my running total at the top of the report by scheduled. Change-Control-Maintenance.rpt
Maliki HassaniAuthor Commented:
Got it!
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.

All Courses

From novice to tech pro — start learning today.