SQL Server Performance

Sorting

Discussion in 'SQL Server 2005 Reporting Services' started by Iamscott, Nov 16, 2007.

  1. Iamscott New Member

    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
  2. satya Moderator

Share This Page