Create a Survey Report

[Clundey]

I am trying to create a report to tally the results of a survey. It comprises 30-40 questions with up to 9 different responses.
I am just looking to count up each response to each question in the least painful way.

Am I doomed to 30*9 running totals?

Thanks for any input!

 

[skuhlman]

I take it that you have one record per response with 30 fields, each representing the answer to a different question. If that's the case, one option would be to create 30ish cross-tab reports in the report footer. Another option is to create formulas to add 1 to the appropriate counter if the right condition is met, but that would be many many formulas. Ideally, if each survey had multiple records (one for each question) with a question identifier and an answer field, you could get away with just one cross tab report in a group footer. Also, you could do some work in a stored procedure to get a working data set if you are using a SQL backend.

 

[IdoMillet]

Doom is a good game )

If you are willing to accept the format limitations, you could use a CrossTab (or several CrossTabs if the possible answer codes are not uniform.

hth,
- Ido CUT (Crystal UTilities): e-mailing, exporting, electronic bursting & distribution of Crystal Reports:

http://sobpc02.bd.psu.edu/CUT/CUT.htm

 

[Clundey]

The fields are the questions. Each record is a survey.

 

[kenhamady]

Add one Cross-tab per question in the report footer.
Use each question field as both the column field and summarized field of its cross-tab. Set it to count. You don't need a row field. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[Clundey]

Thanks Ken! That will work just right!

clundey

 

[satishtiru]

How to get % in the same survey instead of numbers?

Thanks

 

[chelseatech]

You need either CR9 which does support % summaries in a cross tab, or revert to Ken's manual crosstab technique for earlier versions. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[kenhamady]

Cross-tabs don't support percentages until v9 Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com