| Author |
Topic |
|
1sabine8
Posting Yak Master
130 Posts |
 Posted - 2008-11-17 : 09:58:28
|
| Hi,I am working on the interactive sorting of a table. i need to put sorting on every column and i have groups in the table. Sorting is working on the first column but it's not on the second. Any useful tips for that?Thanks in advance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-17 : 10:00:14
|
| check if the column is in same datatype as the values. for example, though it contains numeric data, if datatype of underlying column is varchar, it will sort only as per character data.In such cases first convert column to desired datatype and then apply interactive sort. |
 |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2008-11-17 : 10:01:47
|
| Sorting should be handled by the front-end, not the database. It is a presentation issue.If it is not practically useful, then it is practically useless. |
|
|
|
1sabine8
Posting Yak Master
130 Posts |
Posted - 2008-11-17 : 10:23:58
|
| Actually the first and third columns are nvarchar and the second is datetime. Sorting is only working on the first column. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-17 : 11:37:26
|
quote:
Originally posted by 1sabine8
Actually the first and third columns are nvarchar and the second is datetime. Sorting is only working on the first column.
are you doing any conversion in date column? |
|
|
|
1sabine8
Posting Yak Master
130 Posts |
Posted - 2008-11-18 : 03:58:14
|
| No, not at all. It's a datetime field. |
|
|
|
JacksonsDad
Starting Member
1 Post |
Posted - 2008-11-19 : 11:04:26
|
| I am having the exact same problem.I think the major problem here is the fact that I am (and likely 1sabine8) are using Analysis Services as opposed to the traditional relational database. I have no problem accomplishing this with a SQL Query.Column1 toggle sorts Column 1,All other column sort toggles sort on Column 1 as well.Please help...Thanks!JacksonsDad |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-19 : 11:06:40
|
quote:
Originally posted by JacksonsDad
I am having the exact same problem.I think the major problem here is the fact that I am (and likely 1sabine8) are using Analysis Services as opposed to the traditional relational database. I have no problem accomplishing this with a SQL Query.Column1 toggle sorts Column 1,All other column sort toggles sort on Column 1 as well.Please help...Thanks!JacksonsDad
not sure if its because of report distingusihes it as varchar or any other type. Can you try explicitly casting field value to date using CDATE() and then applying interactive sort? |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2008-11-19 : 11:32:36
|
quote:
Originally posted by blindman
Sorting should be handled by the front-end, not the database. It is a presentation issue.
OK. Just realized this is in the "Analysis Server and Reporting Services (2005)" forum.Duh......I'm going to get another cup of coffee.If it is not practically useful, then it is practically useless. |
|
|
|
|
Interactive Sorting