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

Crystal Reports: Create a totals amount at end of report

Experts,

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
Thanks,
Change-Control-Report.rpt
0
Maliki Hassani
Asked:
Maliki Hassani
  • 2
2 Solutions
 
JayConverseCommented:
Make a formula like:

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

and sum that formula
0
 
mlmccCommented:
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.

mlmcc
0
 
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
0
 
Maliki HassaniAuthor Commented:
Got it!
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

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

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