Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3572
  • Last Modified:

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
0
psokolo
Asked:
psokolo
  • 3
  • 3
1 Solution
 
bdreed35Commented:
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
 
ebolekCommented:
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
 
bdreed35Commented:
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
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
ebolekCommented:
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
 
bdreed35Commented:
No problem.  For that matter, you could also create a Running Total.
0
 
psokoloAuthor Commented:
thank you very much
0
 
ebolekCommented:
Glad i could help

Regards
Emre
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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