Working on Sql Server 2008 R2 - report Builder Why isn't my text field sorting alphabetically?

0 votes
asked Mar 13, 2016 by harville (590 points)
I have column in Report builder that is being grouped by line then sorted by line. problem is that column is grouping and sorting based on number at end of field, e.

4 Answers

–1 vote
answered May 8, 2016 by jne_java (1,940 points)
Best answer
You can also have a look at Sorting by date (not alphabetically by month name) in SSRS ... for inspiration
You can read it here
commented May 8, 2016 by iny_The (100 points)
I have this problem all the time. The function code is just copied
+1 vote
answered Mar 18, 2016 by frp_only (820 points)

Select Enable interactive sort on this text box.
commented Mar 20, 2016 by Nof_Adam (1,080 points)
Most people have this enabled for obvious reasons
0 votes
answered Mar 18, 2016 by heggestad (380 points)
commented Mar 20, 2016 by example (390 points)
Your code should work as you have it see this fiddle. Add your new app to the list of installed apps
0 votes
answered May 9, 2016 by seemoel (1,550 points)
Are you aComputer / IT professional

What is Geekub?

Q&A site for professional and enthusiast programmers, software developers and other technical users. With your help, we hope to work together to build a library of detailed answers to just about any question that is related to programming!