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