Sorting | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Sorting

Hello All! My report has the columns: Date, Year, Model, Cost, Color etc. I have users that will require the abililty to sort reports by multiple criteria at one time. Is it possible to configure a primary AND secondary AND maybe a THIRD sort in Reporting Services? For example: Sort the columns as: Date, then Model and then Cost at the same time? This sorting criteria will change based on the user and the info sought. So another user may want to
sort on Cost and Year, while another person wants Color,Cost, Year etc.. Currently, as far as I know, Reporting Services limits you to one column sort at a time in a report. Thanks in advance ! Scott

You should be able to achieve that using SSRS – http://www.microsoft.com/technet/prodtechnol/sql/2005/2005ssrs.mspx

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |