By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,190 Members | 2,204 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,190 IT Pros & Developers. It's quick & easy.

Crosstab Query: Sort Column heading based on other column sort

P: n/a
Hi,
I have created a report based on a cross tab query and would like to
Sort the column heading of the report based on the sort order of
another field.
I have three tables called survey results, survey questions and survey
response choices. Survey response choices has over 800 choices types.
Survey results capture results of all the surveys and has questions,
respondent, response choice, response, responsechoice order which
looks like this
Question Respondent Questionchoice Response Responseorder
1 1 Agree 20%
2
1 1 Strongly Agree 10% 1
1 1 Disagree 30% 3

1 1 Strongly Disagree 10% 4
and so on. With the help of this group I could create a report where
column heading values change based on the question. My problem is user
wants to see the result set in response order they have identified. In
this case:
Quesion 1 Respondent 1
Strongly Agree Agree Disgaree Strongly Disagree
10% 20% 30% 10%
and so on. The order keeps on changing based on the user input for
Response order.
Since there are over 800 response choices I can not put the response
choices in the Pivot of crosstab query sql view.
Any help would be appreciated.
Reply

Dec 22 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.