Posted: October 27th, 2009    By: Devin Walker   

formsIconLargeManagers need to know what their employees are working on each week, any road blocks they are facing, and which tasks were completed. The best way to collect this information is through a Status Report. The following template is a simple Status Report form that is browser compatible.

Below is a preview image of the form. The company I work for requested that the First Name, Last Name, Title, Phone Number and Week Ending fields be pre-populated when the user opens the form in their browser. I thought this was not possible with browser compatible forms (because of the receiving Data connection from MOSS) and I had briefly attempted to automatically populate fields in a past project which eventually lead to more headache than production (I remember being frustrated that the form had to be administrator approved). Until I stumbled onto a very valuable blog posting.

InfoPath%20Template

The first post I found that related to finding User Information through a Microsoft Office Sharepoint Services web service uses a coded approach, which you should always be careful when any form needs custom code. There most likely is a better way… The second post uses a No-Code approach that grabs the information by filtering the GetUserProfileByName within the http://ServerName/_vti_bin/UserProfileService.asmx web service. Please read the second post to achieve the same results for this template.

Preview:

preview

Download: Weekly Status Report Template

Please Note: After you download the file and open it in Design mode you may receive the following popup message:

warning

This is because the fields are already setup to use the MOSS web service data connection to pre-populate the fields.

Related posts:

  1. SharePoint Color Coated Calendars I found a particularly good blog about how to color your Calendar lists similar to the way Outlook’s are formatted using the Content Editor Web Part and some nifty Javascript HERE.  This particularly valuable post comes to you from PlanetWilson SharePoint Blog, a particularly good source of information for MOSS solution.  There is a packaged [...]...
  2. How to Move SharePoint Calendars Fast Moving a calendar list between site collections may be confusing, but it is actually very simple! This article demonstrates one method using list templates and Windows Explorer to move SharePoint Calendars fast.  Don’t worry, all your content will be moved also.  Let’s begin: You must have proper permissions between the two site collections to perform [...]...
  3. SharePoint deployment strategies overview Companies considering a deployment of Microsoft Office SharePoint Server should review a number of key factors to cost-effectively engage their organization with the product. The following post will familiarize you with some of the typical deployment strategies in a high level overview. There are many methods to consider when deploying a SharePoint solution within any [...]...
  4. Expand/Collapse Browser Compatible InfoPath Forms Do you have an InfoPath form that is browser compatible that needs to be trimmed down? Hide some sections with this method of creating expand/collapse, +/- , and hide/show, option buttons within InfoPath forms limited to browser compatibility.   1. Execute InfoPath 2007 and Design a Form Template… 2. For this example we will design [...]...
  5. SharePoint Stsadm GUI Interface stsadm.exe is a very useful SharePoint Administrative tool and is often used to complete numerous daily tasks.  The tool is command line interface, and some people these days would prefer to work with a more familiar point and click graphical user interface.   The following tool should suit your needs. Available:  Here Size: zipped >100kb Preview [...]...
  • jignesh

    Just read your post. Another team requested to have a status report available on their sharepoint site.

    Need help how do i upload it to my site?

    Please email me @ jignesh.shah@pni.com

  • http:/www.dlocc.com Devin Walker

    Please refer to the Microsoft instructions found HERE entitled “Deploy and manage browser-compatible form templates”. Let me know if you are still having trouble after that.

  • http://www.equifax.com John Karpiel

    I am interested in devloping a very simple progress reporting tool for my boss. We have a small group and he needs tha same information re-created in 7 different reporting paths.

    Can I use this form to consolidate the individaul person reports into a single group report?

    Can I selectively take parts of each submission and connect (through ODBC?) to the various reporting paths. All of the paths use an ODBC compliant MS product (Word, Access, Excel)

    Our sharepoint site is centrally managed. What kind of accerss rights do I need to be able to implement this form?