• Replies 3 replies
  • Subscribers 338 subscribers
  • Views 0 views
  • Users 0 members are here
Related

Multi-Sort in SSRS

Brian Graham
$organization

Anyone know a trick for (for lack of a better name) multi-sorting in SSRS? 

In InfoMaker you could make columns sortable and Ctrl+Click on multiple column headers to sort by one first then another. Is there a way to do that in an SSRS report?

  • $organization

    And I just figured it out. Shift, not Ctrl. Works just the same. No need to do anything differently in the setup.

  • $organization
    As long as you have Interactive Sorting setup on the column header, you can Shift + Click to achieve the same results, I believe. 

    ---------
    Beth Gilliland


    On Mar 29, 2013, at 6:52 PM, Brian Graham <bounce-briangraham8283@tessituranetwork.com> wrote:

    Anyone know a trick for (for lack of a better name) multi-sorting in SSRS? 

    In InfoMaker you could make columns sortable and Ctrl+Click on multiple column headers to sort by one first then another. Is there a way to do that in an SSRS report?




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
  • $organization

    Hi Brian,

     

    I think you can and it is described in this article: http://lukehayler.com/2011/04/28/sorting-on-multiple-columns-in-ssrs/.  It appears you use the Shift key to do it.

     

    Thanks,

    David

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Brian Graham
    Sent: Friday, March 29, 2013 3:53 PM
    To: David Frederick
    Subject: [Tessitura Technical Forum] Multi-Sort in SSRS

     

    Anyone know a trick for (for lack of a better name) multi-sorting in SSRS? 

    In InfoMaker you could make columns sortable and Ctrl+Click on multiple column headers to sort by one first then another. Is there a way to do that in an SSRS report?




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!