Crystal Report-HOWTO get count of each specific answer?

[Thom]

Hi all! I've been searching thru the forum & I can't find my answer; I'm using Crystal Reports 4.6.1.0 that comes free with VB6.0(please forgive me <sg>!)

What I need the report I'm building for a new employee test to do is to break down the specific number of each answer to a survey question; i.e. Yes=1, N/A=2, & No=3 for each question.

How do I build a formula which shows HOW MANY users answered Yes, how many answered N/A, & how many No for each question?

so it will format like:

Question Number: 1
# Yes 4
# N/A 2
# No 3

I've already figured out how to get the Total number or respondents, and the average for each question-I just can't figure the specific formula for the above. Could anyone PLEASE show the SPECIFIC formula I could use for this(this is my first time with Crystal reports!) I'd REALLY appreciate it!

[gerard]

if you upgrade to version 7 and above there are a few additional features such as running totals that would make this easier. But you should be able to do this in version 4.

At the detail level make the following three formulas:

if answer = "Yes" then
1
else
0
Then you just use a subtotal or grand total over this formula...do this for each answer. I would also hide the detail section or the actual formula depending on what you want to display.

Let me know if this answer your question....