Support Forums : The excel report standard format is sorted by count?

Hi SG,

When I draw a report on a single radiobutton or checkbox question, I get the responses out in excel sorted by count. So the options that have recieved most responses are in the top of the table and the ones with least are at the bottom. Is there a reason for this? I would much rather have them shown the way I constructed the question, so that I can copy paste the data easily into a premade calculation sheet.

Is there any way to change the report so that it shows the responses in the same order as the survey was designed?

Also I think I mentioned this before and got an answer, it is crucial to be able to see what options in such questions have not recieved any responses. At the moment they are simply left out of the report.

Thanks for the support. I am about to lauch my first data collection for our consultancy product and can not wait to see how it goes.

/Ulrik

Thanks for the answer. I am back from holiday now.

It is too bad that I cannot see the options not chosen in the excel report format. This leaves me with a format that is virtually unusable in professional terms since I would manually have to examine each and every question for unanswered options and add them into the sheet manually to be able to pull out any graphs or use the information in any other way than the original report.