How to create a questionnaire survey report

[c8ltgkue]

Hi All

Using CR XI

I have to create a report on answers given to a questionnaire survey.

Here are some sample questions

Q1 – How would you rate the services provided by the salesman?
A1 – Excellent
A2 – Good
A3 – Poor

Q2 – Did you think the salesman had adequate knowledge of the product?
A1- Yes
A2 – No


Many customers could give feedback for one salesmen. I would like the report to look something like this:


Assuming Salesman A had feedback from 100 customers.


Salesman A

Q1 – How would you rate the services provided by the salesman?
A1 – Excellent 70
A2 – Good 20
A3 – Poor 10

Q2 – Did you think the salesman had adequate knowledge of the product?
A1- Yes 85
A2 – No 15

My report is structured as below:

GH 1 Salesman name
GH 2 Question Text
GH3 Answer Options summary count(answer values)
D Purchase ID, Question no, Answer value (suppressed)

My report looks like this:

Salesman A

Q1 – How would you rate the services provided by the salesman?
A1 – Excellent 100
A2 – Good 100
A3 – Poor 100

Q2 – Did you think the salesman had adequate knowledge of the product?
A1- Yes 100
A2 – No 100


I need a COUNTIF formula but I know there is no such thing in Crystal. Does anyone have any alternative solutions ?

Many thanks in adv.

C8

 

[dgillz]

If {Question1Answer} = "A" then 1 else 0

Sum this formula.

Create as man similar formulas as necessary to get all the totals you need.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?