Solved

Sorting in SharePoint

Posted on 2011-03-08
5
329 Views
Last Modified: 2012-06-21
If you look at the attached picuture you can see how sharepoint is sorting my documents. I need it to sort by more digits than it is.  

I dont want it sorting like

02-01
02-100
02-65

I need 02-65 Above 02-100 if that makes since. If not please let me know.
SOP.png
0
Comment
Question by:rstahl08
5 Comments
 
LVL 15

Accepted Solution

by:
wantabe2 earned 250 total points
Comment Utility
I had the same issue. It's all in the sort setting unser site actions. Take a look at this link, it gets you to the area you need to adjust the sort settings.

http://social.technet.microsoft.com/Forums/en-US/sharepointadmin/thread/9a9b091e-3957-4851-b5f7-66767c667be7
0
 
LVL 5

Assisted Solution

by:navtej_dhillon
navtej_dhillon earned 250 total points
Comment Utility
Sharepoint is considering this field as string and sorting it on String basis only, i.e. why u r not getting ur desired results (Bcoz Name is a mix of string & int).

I don' think u will be able to modify this sorting behavior in SP, instead u can try creating another column based on this Name column and sort basis on that custom column.

~Amit
0
 
LVL 1

Author Comment

by:rstahl08
Comment Utility
Looking at your link want I need to enable Publishing Features.  Unfourtanly that feature is only in MOSS 2007-10. Not 3.0, so I guess I need to seek approval for 2010 purchase :-)
0
 
LVL 4

Expert Comment

by:TEEDA
Comment Utility
I think  navtej dhillon is right- we had a similar problem with a document library for meeting documents, where the documents needed to be listed in the order they appeared on the agenda.  We created a column called Agenda Order of type number and used it to sort the items in the library.  
0
 
LVL 1

Author Closing Comment

by:rstahl08
Comment Utility
I will justy have to play around with it. Thank you!
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

MS Access 2003 or later To MySQL Migration Project Hello All, this is my second article in the category of MS-OFFICE Automation. In internet I am not able to find any comprehensive resource on the Migration of MS Access back-end to MySQL so I fin…
We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

728 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

11 Experts available now in Live!

Get 1:1 Help Now