I'm planning on building a dashboard in SharePoint MOSS 2007. It needs to show the current status of a number of systems, allowing users to manually update the status as and when required. Initially this could just be a text representation of the status i.e. Good / Bad / Ugly
But I'm hoping to display a graphical representation of the status at some point. Has anyone done anything similar or can they suggest what features of SharePoint may help to achieve this?
Any suggestions appreciated!
I can think of 2 quick suggestions
Create an image library to store the graphics you want to display. Then in your systems list, create a "hyperlink or picture" column and set the "Format URL as" option to picture. Then create a sharepoint designer workflow which updates the picture url based on the selection of the drop down of the user. (in other words, get the url of the picture from the image library where the name of the image is the same as the name of the item in the drop down).
You will then need to create a view of the list incorporating the image field (showing as picture not url). Add a web part into your page based on the view of the list just created.
You could probably achieve a Red/Amber/Green status view by creating an out of the box KPI list, and adding a KPI item based on your list which can be filtered and calculated on. (you need publishing features turned on for KPI Lists)
Add in the KPI web part which gets its info from the KPI list item you just created.