Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 Sorting on any column

Author  Topic 

mahfoozelahi
Starting Member

5 Posts

Posted - 2005-03-22 : 13:46:25
How do Provide sorting feature to all the columns in a report so that user can sort the report on any column?

Mahfooz

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-03-22 : 15:54:33
The way I see it working in the current version is that you'd have a report parameter that would accept the column to be sorted by. Then your stored procedure would accept this value and handle the sorting. This can be done via:

http://www.sqlteam.com/item.asp?ItemID=2209

Make sure to check out the comments of that article as it discusses the data types issues and resolution with this solution.

Tara
Go to Top of Page
   

- Advertisement -