Search This Blog

Wednesday, October 6, 2010

List does not display in Datasheet view

When you open a List, it won't open in Datasheet view.

Category: SharePoint 2010

You see the following error message:

The list is displayed in Standard view. It cannot be displayed in Datasheet view for one or more of the following reasons: A datasheet component compatible with Microsoft SharePoint Foundation is not installed, your browser does not support ActiveX controls, a component is not properly configured for 32-bit or 64-bit support, or support for ActiveX controls is disabled.

To solve this problem simply download and install the following on the user PC:

2007 Office System Driver: Data Connectivity Components which can be found at the link below.


Approximately 25 MB in size


Any questions please just ask. Any alternative suggestions please let me know.

Cheers

Derek

How to display the List item ID at the top of the List Item window

Display the List item ID at the top of the List item window.

Category: SharePoint 2010


This is useful when you need to print out a single List item (see how to print a single List item) and share with your team.

Thank you to Christophe@PathToSharePoint.com for the code to display the List Item ID.

a.      Open the List
b.      Hit the List tab
c.      Click the Form Web Parts dropdownlist
d.      Choose “Default Display Form”
e.      At the top of the Page – Insert Tab, Click the Web Part button to add a new Content Editor web part.
f.       From Categories choose “Media and Content” > “Content Editor” and add it to the main section of the page
g.      Click the “Click here to add content” and then click the HTML button in the Ribbon to bring up the Edit source code window.
h.      In the window add the following code to display the Item ID at the top of the list item window.
i.       <code>
<script type="text/javascript">
               //
               // Item ID in DispForm.aspx and EditForm.aspx
               // Feedback and questions: Christophe@PathToSharePoint.com
               //
               function DisplayItemID()
               {
               var regex = new RegExp("[\\?&]"+"ID"+"=([^&#]*)");
               var qs = regex.exec(window.location.href);
               var TD1 = document.createElement("TD");
               TD1.className = "ms-formlabel";
               TD1.innerHTML = "<h3 class='ms-standardheader'>Issue ID</h3>";
               var TD2 = document.createElement("TD");
               TD2.className = "ms-formbody";
               TD2.innerHTML = qs[1];
               var IdRow = document.createElement("TR");
               IdRow.appendChild(TD1);
               IdRow.appendChild(TD2);
               var ItemBody = GetSelectedElement(document.getElementById("idAttachmentsRow"),"TABLE").getElementsByTagName("TBODY")[0];
               ItemBody.insertBefore(IdRow,ItemBody.firstChild);
               }
                
               _spBodyOnLoadFunctionNames.push("DisplayItemID");
               </script></code>
j.      Ignore any Warnings! Next hit the Page tab at the top of the page and view the list item. Done!

Any questions please just ask.

Derek 

Print a single List item in SharePoint 2010

How to print a single list item in SharePoint 2010

Category: SharePoint 2010


You may need to print a single list item in SharePoint 2010. However, this functionality does not exist unless you print with Excel, which isn't what you are looking for anyway.


So, how do we go about accomplishing this?

  1. Open a List
  2. Hit the List tab
  3. Click the Form Web Parts dropdownlist
  4. Choose “Default Display Form”
  5. At the top of the Page – Insert Tab, Click the Web Part button to add a new Content Editor web part (CEWP).
  6. From Categories choose “Media and Content” > “Content Editor” and add it to the main section of the page.
  7. Click the “Click here to add content” and then click the HTML button in the Ribbon to bring up the Edit source code window.
  8. In the window add the following code to display a Print Button at the top of the list item window.
    <code>
        <input type="button" value=" Print this page " onclick="window.print();return false;" /> 
    </code>

  9. Ignore any warnings.

  10. Next, hit the Page tab at the top of the page to view the List item. You should see the Print button.

  11. Hit the Print button to print just the list item.
So there you go, with just a little tweaking you can print a single List item.

Any questions please just ask.

Derek