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.
| Author |
Topic |
|
scottd
Starting Member
11 Posts |
 Posted - 2007-11-16 : 10:01:04
|
| Hello All!My report has columns Date, Year, Model, Cost, Color etc.I have users that will require the abililty to sort reports by multiple criteria.Is it possible to configure a primary AND secondary AND maybe a THIRD sort in Reporting Services?For example: Sort the columns as: Date, Model and Cost at the same time? This sorting criteria will change based on the user and the info sought. So another user may want tosort 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 |
|
|
gavakie
Posting Yak Master
221 Posts |
Posted - 2007-11-16 : 11:40:02
|
| The only thing I know is you can click on the properties of say a table your using, click on the sorting tab and then sort by multiple things. I dont know how you can per user though. Sorry if that doesnt help. |
 |
|
|
RobertParker
Starting Member
10 Posts |
Posted - 2007-11-17 : 07:39:52
|
| Do you want a user defined sort or is the sort method static?If it's just static then create a group, and put several different sort expressions in it. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2007-12-03 : 11:41:41
|
| one method would be to add three parameters as Sorting criteria and use them inside the sort tab of table to sort as per user input. |
|
|
|
|
|
|
Multiple Sorting on a report