I have a standard list with data such as this for different projects I am running


How can I create a view with this data summarised


I dont have access to load any new webparts or anything like that, I am stuck with whatever the IT cops have given us. I am open to hacking at it with jQuery if that would work



You could also do something with XSLT. For a standard list view the XSL file can live in any document library so you would not need any special access so long as you can edit the page.

I have a post on how to create a project dashboard on my blog - http://paylord.wordpress.com

| improve this answer | |

Creating custom views can be done in the standard interface with no custom code. Just go to the list's main page, then the Library tab and you will see the option there.

Here is an instructional video.

If you are interested in hacking it with some jQuery take a looks at the ListData.svc (an OData web service that can return JSON). I use it in combination with Kendo UI to do a lot of different thing. If you want some more information on that, you should probably open a new question, though or edit this one to be more specific.

Here are some other topics you might wish to research:

The Data View Web Part

WebParts for View and Forms

| improve this answer | |

Just create a plain, standard list view and use the grouping options. Group by the month, then by colour. Then total by project.

If you have access to SharePoint Designer, you can create a prettier result with a Data View Web Part instead of an XSLT List View.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.