Sorting in report builder 3.0

Posted on 2012-08-18
Last Modified: 2012-08-23
I am trying to sort a report by date and various fields. i have tried on the back end with an order by in the query. when i run the report it does not sort that way?

  ,View_AlamedaCityFD_Completion.[Checked out By]
  ,View_AlamedaCityFD_Completion.[Dup Status]

order by tdate asc, shift

Example of report -
Question by:srodgers45
    LVL 13

    Expert Comment

    Check your data set and table properties if the sorting is set there

    Author Comment

    I have tried the individual tables sorting properties. In the tablix properties it doesn't sort when i enter the choice in the drop down? Is there any reference you can provide.

    LVL 22

    Accepted Solution

    Looks like you group by INC. NUMBER. Grouping is done first, then sorting. AS you can see the records are sorted by date withing the group.

    Author Closing Comment

    Thanks, i rearranged the groups, seems to be working okay now.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
    Introduction Earlier I wrote an article about the new lookup functions ( that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now