June 30, 2014 at 2:58 pm
Hi, I'm on SQLServer 2012 with most recent pack.
I have a report running on sp, and I'm getting this results from sp in SSMS order by Name:
Abbielle -- this is correct ASCII collation
Adriannita
Aimeel
Alice
Amparom
Amy
Andrea
And this results on my rdl report: , looks like it cares only about first char and don't do any collation on anything after that:
Amparom
Amy
Andrea
Aimeel
Alice
Abbielle
Adriannita
What is wrong here ? why I dont' get same order ?? I recheck my sp, confirmed that worked against the right one, dont' have any SORT in any groups inside rdl??
sp has select c1,.... from t1 order BY NAME.
This is really killing me .
I just retested ti sorting on numeric column and it works OK, like desighned, but for Alpha looks like a problem.
Tx all
M
June 30, 2014 at 3:43 pm
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?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply