471,579 Members | 1,917 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,579 software developers and data experts.

Crosstab Query: Sort Column heading based on other column sort

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
0 2007

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Tom | last post: by
1 post views Thread by Nathan Bloomfield | last post: by
3 posts views Thread by Paula | last post: by
2 posts views Thread by deejayquai | last post: by
2 posts views Thread by Nenad Markovic | last post: by
1 post views Thread by GLEberts | last post: by
reply views Thread by XIAOLAOHU | last post: by
reply views Thread by Vinnie | last post: by
1 post views Thread by lumer26 | last post: by
reply views Thread by lumer26 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.