I've just started using crystal Reports and I am looking for help in designing a report for summerizing survey results. The database is an Access database. There is a numberic field that holds the response to each of the 10 questions. Each question askes the person taking the survey to rate their response on a 1 to 5 scale. The value they enter is stored in the database field for that question. So each survey is one records with 10 fields holding values 1 thru 5. I need a report that will show the number of responses for each of the 1 thru 5 values for each question. So the report will look like:
1. How well do you like our fried chicken: 1 2 3 4 5
12% 10% 8% 10% 70%
2. How clean are the restrooms 22% 31% 19% 20% 18%
How do I get Crystal reports to generate a report like this?