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:

Maybe try and use multiple crosstabs (one per question)

Edited by DBlank - 05 Oct 2009 at 11:25am