|
I have a list in which users can register some distances. On a page somewhere else on the SharePoint site I would like to show the total distance based on the list and compare that to a goal distance. Which method would you use and how would you make it nice looking/appealing? There will probably be 2-3 values that should be shown on the page (also calculated from a list). |
|||||||
|
|
No shortage of responses here! (And thanks, Jaap for mentioning my jQuery Library for SharePoint Web Services as an option.) I would probably start with a Data View Web Part (DVWP) because I take the "on a page somewhere else on the SharePoint site" part of your question as meaning that the list is in a different site in the Site Collection than where you would like to display it. (The terms site/web/Site Collection/subsite/etc. are used inconsistently even by Microsoft and even across access methods!) |
|||||||||||
|
|
Alternatively, you could use jQuery and the SharePoint web services. Check out Marc D Anderson's jQuery Library for SharePoint Web Services for a quick and easy way to develop against the SP web services using jQuery. |
|||
|
|
|
The spec is a bit thin, but AFAICS you should be able to do this with OOTB web parts like Content Query Web Part. hth Anders Rask Some references on CQWP: http://msdn.microsoft.com/en-us/library/ee413993.aspx http://msdn.microsoft.com/en-us/library/bb447557.aspx http://msdn.microsoft.com/en-us/library/aa981241.aspx http://msdn.microsoft.com/en-us/library/ms497457.aspx |
|||
|
|
|
You can display any list as a web part on any page and choose which columns from the list you wan to see. To see this in action, on the default page, click Site Actions, Edit Page, Add Web Part, choose any of the web parts from the Lists and Libraries section, then Edit the Current View (in the web part's task pane). You could put the goals into a separate column in the same list OR if you have MOSS Enterprise Edition you can use the KPI web parts to manage your goals OR you can do something like what is shown at http://www.pathtosharepoint.com/Pages/ProgramsDashboard.aspx. Lots of choices |
|||
|
|
|
Another method (if you are running MOSS) would be to create a KPI list. Each item in this list is an indicator: a calculation from another data source with thresholds to trigger goals and warnings. For Total Distance, you would add an indicator that pulls from the list that registers distance and sums that distance. When you click on the title link of this indicator, it will show a page that includes the Total Distance. After you have all of your indicators, you could create a page with KPI Detail web parts for each indicator you would like to show. That way, you could include all your indicators on one page. Here is a step-by-step: Create and publish Key Performance Indicators |
|||
|
|
