SharerPoint V3.0, Project Management Template - Dashboard View
In the Overall Project Status, the last category to the right is the "Overdue Tasks" icon.How does sharepoint determine if a Task is Overdue for this specific Icon. Here is what is happenning to me:Current Date = 11/5/2008Any Task with an End Date of 11/6/2008 - 12/31/2008 is fine.However, this icon is showing a task as overdue if the date is 1/1/2009 - 11/4/2009 and NOT overdue if the date is 11/6/2009 - 12/31/2009?The "Overdue Tasks" view is working as expected, it is showing only tasks with an End Date of Less than Current Date and not = to Complete. Why is the icon on the Dashboard working differently? Where is the setting for this icon located so I can change it?Any help is greatly appreciatedDave at MB
November 5th, 2008 3:54pm

This "Project Management Template" is presumably one of the "Fantastic 40" WSS 3.0 Application Templates ?Moving this to the Admin forum as it seems that you are asking questions about how this works out-of-the-box.
Free Windows Admin Tool Kit Click here and download it now
November 6th, 2008 12:30am

Hi, Could you please specify which template are you using? I have check the names of all the templates, but I cannot find the Project Management Template. Please refer to Application Templates for Windows SharePoint Services 3.0 (http://technet.microsoft.com/en-us/windowsserver/sharepoint/bb407286.aspx) and let us know the correct template name. -lambert Posting is provided "AS IS" with no warranties, and confers no rights.
November 9th, 2008 10:29pm

I am using the "Budgeting and Tracking Multiple Projects" Template.Dave
Free Windows Admin Tool Kit Click here and download it now
November 11th, 2008 10:24am

Hi Dave, I have confirmed your issue in my test environment. The cause of the issue is the logic that estimates the Overdue items is not perfect. You could locate the logic the following detailed steps: 1. Navigate to the Dashboard in Project Management Section. 2. Modify the Overall Project Status web part, Click the XSL Editor. 3. In the opening dialog window, locate to the following highlighted code: <!-- Overdue Tasks --> <td class="ms-vb" style="text-align:right; height: 22px; vertical-align:middle;"> <span style="vertical-align:middle"> <xsl:value-of select="count($FilteredPeerTasks[@Status != 'Completed' and (substring-before(@DueDate,'-') &lt; substring-before(ddwrt:TodayIso(),'-') or substring(@DueDate,6,2) &lt; substring(ddwrt:TodayIso(),6,2) or substring(@DueDate,9,2) &lt; substring(ddwrt:TodayIso(),9,2))])"/> </span> <xsl:text xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime" ddwrt:nbsp-preserve="yes" disable-output-escaping="yes">&amp;nbsp;</xsl:text>&#160;&#160; <xsl:choose> <xsl:when test="count($FilteredPeerTasks[@Status != 'Completed' and (substring-before(@DueDate,'-') &lt; substring-before(ddwrt:TodayIso(),'-') or substring(@DueDate,6,2) &lt; substring(ddwrt:TodayIso(),6,2) or substring(@DueDate,9,2) &lt; substring(ddwrt:TodayIso(),9,2))]) = 0 "> <img src="images/KPI-0.gif" originalAttribute="src" originalPath="images/KPI-0.gif" originalAttribute="src" originalPath="images/KPI-0.gif" originalAttribute="src" originalPath="images/KPI-0.gif" originalAttribute="src" originalPath="images/KPI-0.gif" align="absmiddle"/> </xsl:when> <xsl:when test="count($FilteredPeerTasks[@Status != 'Completed' and (substring-before(@DueDate,'-') &lt; substring-before(ddwrt:TodayIso(),'-') or substring(@DueDate,6,2) &lt; substring(ddwrt:TodayIso(),6,2) or substring(@DueDate,9,2) &lt; substring(ddwrt:TodayIso(),9,2))]) &lt; 5"> <img src="images/KPI-1.gif" originalAttribute="src" originalPath="images/KPI-1.gif" originalAttribute="src" originalPath="images/KPI-1.gif" originalAttribute="src" originalPath="images/KPI-1.gif" originalAttribute="src" originalPath="images/KPI-1.gif" align="absmiddle"/> </xsl:when> <xsl:otherwise> <img src="images/KPI-2.gif" originalAttribute="src" originalPath="images/KPI-2.gif" originalAttribute="src" originalPath="images/KPI-2.gif" originalAttribute="src" originalPath="images/KPI-2.gif" originalAttribute="src" originalPath="images/KPI-2.gif" align="absmiddle"/> </xsl:otherwise> </xsl:choose> </td> If you are familiar with coding, you may find the logic is not perfect. The logic divide the date into Year, Month and Day, and then estimates separately. As we have not announced an official update, I suggest you to amend it by yourself. And I will give code sample written by me for your reference: number(substring(translate(@DueDate,'-',''),1,8)) &lt; number(substring(translate(ddwrt:TodayIso(),'-',''),1,8)) you could copy the code and replace the highlighted part. PLEASE NOTE: The code is not well tested, and I do not guarantee there will not be errors, so some minor debugging may be needed and you should modify based on your requirement. -lambertPosting is provided "AS IS" with no warranties, and confers no rights.
November 11th, 2008 11:45pm

Thank you for your research and reply.As I am not a developer, this is something we will have to live with until this fix is released. At least I know it wasn't something I was doing.Dave at MB
Free Windows Admin Tool Kit Click here and download it now
November 12th, 2008 9:43am

Hi, I confirm you that until now your code works well. Regards,Sebastian
July 30th, 2009 12:42pm

Lambert - Thanks for the code! That corrected the issue.
Free Windows Admin Tool Kit Click here and download it now
August 10th, 2009 10:36pm

Thanks Lambert, worked like a charm!
August 8th, 2012 3:00pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics