Crystal Reports - Count Formula

crystal-reports crystal-reports-2008 crystal-reports-8.5
Trish picture Trish · Jan 9, 2012 · Viewed 44.7k times · Source

I am developing a report in Crystal and I need to do a count on a particular field that has several different statuses. For example, I have a "StatusType" field in my report that contains values that are "In Process", "Rejected", "On Hold", or "Submitted". I want to be able to do a count on the "StatusType" field as to how many values are "Rejected" and "Submitted" in one formula. The report is grouped by "StatusType".

I'm new to writing formulas in Crystal Reports so would appreciate some guidance with getting a formula that will count those two values in the field. Please let me know what additional information is needed or would be helpful to assist with my question.

I do not need to display the total count for each Status Type at the start/end of each group, but would like to in the page or report header. I'm not sure which would be best. I would like to have counts of each status in one spot on the report and then be able to combine a couple of the status counts, such as the "Rejected" and "Submitted". None of the counts I want to display need to be within the body of the report or within the details but rather in the report/page header.

Answer

codingbadger picture codingbadger · Jan 9, 2012

I think the best option here would be to use a RunningTotal rather than a formula.

Create a new Running Total and enter the following options:

  • Fields to summarize: {StatusType}
  • Type of Summary: Count
  • Evaluate: Check Use a Formula and press the formula button.
  • In the formula box enter {StatusType} = "Submitted"
  • Reset: Check Never

I don't have Crystal installed on this machine at the moment but I think that should do it. Then you can just repeat the process for the Rejected status type.

Related questions

How to create Table in Crystal Report

Create Table in Crystal Report I am newbie to Crystal Report, and i am using Crystal Report 2008. I want to know, do we have table object in Crystal Report.. so that i can draw a table with specific rows and …

Read More
Summation of Sum Formula in Crystal Report

I did a summation in one formula say Formula1. Now i created Formula2 which would do summation of Formula1 as Sum({@Formula1}). But the crystal report gives the error as "The Field could not be summarized". I understand that summation …

Read More
My Crystal Report is not getting refreshed while passing parameter?

I have created my Crystal Reports using SQL query in Crystal Reports itself, by passing two parameters, i.e, say for eg:- Month & Year. While I preview the report, I can able to navigate through all pages by …

Read More