Counting summaries

[benshsms]

a very basic crystal problem really but one of those need to knows...

Have a database table

Problem ID Severity
E-122 1
E-23 1
E-212 2

And I need to present a report that shows.

SEVERITY LEVEL NUMBER OF OCCURENCES
1 2
2 1
3 0

I've tried using the grouping but this causes issues in the report presentation - are there formula(s) I can write that just return a report as indicated.

Thanks!

 

[kphu]

Try this out.

create a grouping for severity.

create a count for the field severity


let me know if you don't understand how to do this.

Ken

 

[lbass]

If you cannot group by security then use the running total expert. For each severity level, create a separate running total by selecting {table.problemID}, count (or distinctcount, if there should be only one severity level per problemID and if there is the potential for duplicates),
evaluate based on a formula:

{table.severity} = 1 //change this to 2 or 3 for the other running totals

Reset never, or if you want the counts at a group level, use on change of group.

If you have no duplicates, you could also use a formula approach, creating three formulas like:

//{@Severity1} to be placed in the detail section:
if {table.severity} = 1 then 1 else 0 //change severity levels for the other two formulas

Then insert summaries (SUMS, not counts) on these at group and/or report levels.

-LB