# HOW TO COUNT TRUE VALUES IN CRYSTAL REPORT.

I have a formula set up to filter data in a column.
{tbOrders.OrderStatus}=220
It gives out me a boolean parameter true or false. What I need now is a count of positive  records(true).
In general i need to have a count of '220' record in a column grouped by another column(time).
Can anyone help me with that ??
Pawel
###### Who is Participating?

x

Commented:
Bdreed solution will work but if you dont want ti insert summaries you can get the total count in one formula like this. I have adjusted breeds formula

Regards
Emre

@Count_True

numbervar totalcount;

If {table.field} = True then
totalcount := totalcount +1
else
totalcount := totalcount
0

Commented:
If you only want to count true values, create a formula to return a 1 or 0.

@Count_True

If {table.field} = True then
1
else
0

Place the field in your detail section and suppress it.
Right click the field and choose Insert, Summary.
In the box that opens up, the formula should be the field, make sure that summary type is SUM, and change the location to your Time Grouping.
0

Commented:
Emre - This is true, there is mnore than one way to skin a cat.  The only difference is that your solution is only available at the end og a grouping or the report, whereas, is you need the total in the group or report headers, you will have to use the solution that I presented.
0

Commented:
That is true too. I only want to give him the other options like everybody else does. I think it is a good information to know that you can get the summary totals by using formulas too.

Regards
Emre
0

Commented:
No problem.  For that matter, you could also create a Running Total.
0

Author Commented:
thank you very much
0

Commented:

Regards
Emre
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.