Is it possible to sort a MOSS 2007 KPI list alphabetically by title?
I can get the Allitems view of a KPI List to sort alphabetically by Title, but I can not get the "KPI List" view to sort (can't sort any view for that matter--where the status icons show).
It appears that the view with the ICONS will only display as sorted by "ID."
SharePoint will let me "modify this view" and change the settings to sort on Title (and save the new settings), but the display does not change.
I have SharePoint Designer but have not tried that on this problem yet.
1. The KPI List (or any view other than “All Items” view) is a customized list view and can’t be sorted and will always be in the order in which the KPIs were added.
2. ‘Modify This View’ will let you change the sort order and that gets applied only to the ‘All Items’ View.
1. The KPI List (or any view other than “All Items” view) is a customized list view and can’t be sorted and will always be in the order in which the KPIs were added.HI;
I understand your view over "AllItems" View but since these option of moving up and down are there in the KPI list they should work; and if it is not working isi'nt a bug with product?
I am too tired of trying it out in different fashion.
Any help would be much appreciated or if vendor is proposing it as a bug can someone get me the link for the report?
- Edited by Mike Walsh FIN Friday, February 19, 2010 4:56 AM don't use full quote - quote only if necessary and Hi and names aren't necessary to identify what you are replying to
I have been working with MOSS 2007 KPIs' since Jan 07 - and have tried every which way....this is something I hope Microsoft will fix - also get VIEWS in KPI Lists to work- they are also non-functional using out of the box setup and following the same conventions
Add the KPI web part to a page. While still in the page edit mode, Right Click on one of the KPI's and select Move Up or Move Down. This will change the sort order.
M.Killen:Please do not propose your own posts. It isn't helpful.Propose the good answers of other people but wait for someone else to propose (or mark) your posts.(Moderator)
FAQ sites: (SP 2010) http://wssv4faq.mindsharp.com; (v3) http://wssv3faq.mindsharp.com and (WSS 2.0) http://wssv2faq.mindsharp.com
Complete Book Lists (incl. foreign language) on each site.
You can use the Move Up /Down in a KPI list web part. But there are quirks. I answered it at http://social.msdn.microsoft.com/Forums/en/sharepoint2010general/thread/e6e1a32e-caa7-45d8-862a-4482a319a29f
I pulled a lot of my hair out on this one a couple years ago. You need to have the Publishing features enabled and the web part must be on a publishing page. I am guessing there is some JS requirement somewhere. You may be able to hack the reference with SPD
1. Activate publishing infrastructure feature for the site collection
2. Active publishing feature for site
3. Create a web part page in Pages library
4. Add KPI web part
Move up/down will be available. If you want it on the home page, set the welcome page for the site to be in the Pages library.
I know this is an old thread but here is a work around without getting into why it does what it does.
This solution works on SP 2010 but it's based on basic SharePoint so it should work for other versions
1. Browse to the KPIListViewPage you're using
2a. Under the settings tab of the webpart click settings / List settings
2b. Here I created a new text column named Order so I had something to sort by later
2c. This is mostly just to get to the default view or to create a new view in a standard list format
3. Scroll to the bottom and select the All Items view to edit it
4. I selected all the Column Names and then filtered out the ones that were empty keeping the Order column first.
5. Go back to the list view, hopefully it defaults to a list view you just created. You should see all of the KPIs you originally created with all of the pertinent info and linkage
6. Now, click the List tab in the ribbon and select Datasheet View
7. If you want it alphabetized sort it using the Title column or just fill out the Order column and then sort it that way
8. Once it's in the order you want select and copy all of the rows and columns
9. Paste them into the bottom * row (first field)
10. Now on the KPIListViewPage.aspx you should see all of your old ones followed by the newly copied ones.
11. If you like the bottom portion of your list (the ones you just created) great!
12a. Go back to the view you were working in and delete the rows you don't want.
12b. I sorted them by ID and deleted the old copies that way to avoid confusion.
Jason P Heeter
- Proposed as answer by Jason Heeter Monday, June 20, 2016 5:53 PM