Version 10: Changing the output of a count?

[TheElephantMan]

Hello, all.

I have a very simple report with a group that lists employees and the technologies they are familiar with:

Fred
Java
C
Jake
SQL
Visio
Jonas
None

When I use the insert summary option to display a count of each skill, those employees with a skill listing of "None" show a count of 1. I'd like the summary field to output a 0 when the contents of the skill field are "None".

I've created a custom formula count field, but it either displays a zero or a count of all the skills in the database, not just for each employee.

Some help would be appreciated.

Thanks in advance,
TEM

 

[KingfisherINC]

Just have the employees with no skills fired.

Or

Create a formula in the detail section that checks each record and returns a 1 if true, then sum on that formula.

if {Employee.Skill} <> "None" then 1

If there is only ever one record, you could put this in the group header - I'm not a CR expert (this is an Crystal Enterprise Forum) so there maybe better ways - Try posting on Crystal Reports Formulas (shouldn't that be formulae?)

Kingfisher

 

[KingfisherINC]

Of course I mean if you can put the formula in the GH / GF it would be a count of the group.

if {Employee.Skill} <> "None" Then
Count ({Employee.Skill}, {Employee.Name})

I think the former option is safer, but I'm sure someone will give you the definitive answer.

Kingfisher

 

[TheElephantMan]

Kingfisher,

Thanks for the tip, I'll give it a shot. Sorry about the wrong forum; shows how much I know about Crystal, myself.

Thanks,
TEM