Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have a SharePoint 2010 BI Requirement.

I have a custom checklist with over 100 columns. Each item (column) in the list has a status of either complete or incomplete. The default value is incomplete. There will be only 8-12 rows. The title field will be the row identifier. Several of the items have steps that need to be completed in order for the entire item to be complete. In other words, sub-steps. So I have a calculated column that has an IF statement (if steps 1 through x are complete, then display complete in that column, otherwise incomplete).

Example: Checklist item 5 has three sub items. When all three have been completed, then item 5 displays complete.

What I need to do is show each of these columns as a graphic icon. Unfortunately, I cannot have that many calculated columns to produce this effect. See this.

I have worked with SharePoint Designer and the conditional formatting is painful!!! Plus it only works for one particular view. I need to be able to display the icons in different web part views.

Also, the client doesn't want to use the KPI list as that it only displays down the page and not across.

Since I am not a code writer, I am posting this for SharePoint Community to lend some assistance. Any takers?

share|improve this question
1  
If you're open to 3rd party solutions and want something a bit easier to use that SPD then this may help pentalogic.net/sharepoint-products/highlighter –  Ryan Oct 9 '12 at 15:06

2 Answers 2

Here you can use this script to catch the Check and Uncheck event of the checkbox and then show and hide the respective image tag based off that event.

    <script type="text/javascript">

    $('#Checkbox').click(function(){
        var checked_status = this.checked;
        if(checked_status == true) {
            $('#txt').show();
        }
        else { $('#txt').hide();
        }
    }); </script>
share|improve this answer
    
I am not sure how this helps answer the OP's question - what am I missing? –  Ryan Oct 9 '12 at 15:08
    
He simply wants to show an Icon next to a field. I am simply showing him how to modify the HTML to apply an IMG tag next to the Table. I can't give a complete solution because I don't have the code but he just needs to modify the HTML to his liking. –  Joseph D Surgeon Oct 9 '12 at 15:13
    
She wants the icons on a View I believe and they should be dynamic depending on the 'check' status, not static. –  Ryan Oct 9 '12 at 15:30
    
Check out the updated answer –  Joseph D Surgeon Oct 9 '12 at 15:42
    
Thats not going to work on a view - just a form. Even then it will only work on a custom form that has #Checkbox and #txt elements already setup so is only half an answer. Sorry if I am giving you a hard time - not picking on you I just don't see how this helps the OP. –  Ryan Oct 9 '12 at 15:51

I've used a dataview web part before to display my own KPI indicators (from _layouts/images) and percentages of completion of groups of items based on a parent item or piece of metadata. It wasn't too difficult to pull off, but it did get tricky at times.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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