• There are lots of cases where SSRS doesn't care or acknowledge the order in the sp. IF you want the report sorted you need to set the ordering in the report properties.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?