Budgeting and Tracking Multiple Projects Template



    If you have used this template you will notice when you click on a project it displays all of the related tasks.  I am trying create a template just like this (there are a couple of reasons I am not using the one off the site,  but that is another thread).  However I cannot figure out how they are querying the related tasks from this CAML query.  The Project is a lookup column and they seem to fill in the ProjectID with a querystring parameter (I get that), however the project displayed is text not an integer. 


    <View><Query><Where><Eq><FieldRef Name='Project' Type='Integer' LookupId='True'></FieldRef><Value Type='Integer'>{0}</Value></Eq></Where></Query></View>


    So I can see how the {0} is replaced from the querystring but how is the Project replaced with the Project ID from the Project List or is it replaced with the Project Name?


    What am I missing?  Can any reproduce what this template is doing in the dispform for related tasks?





    Tuesday, March 25, 2008 12:06 AM

All replies

  • Sorry I can't be of any help...

    I'm actually trying to do the same exact thing but instead of showing the related items from a list, I want to show the related items from a document library.

    I want to use the template as is, it works great for my purpose, however I want to add this extra element to it.

    Wednesday, April 02, 2008 10:42 PM
  • I'm still trying to figure this out, can anyone help?


    Wednesday, May 07, 2008 3:43 PM
  • Same issue..

    Have been struggling with this for a while.  Somehow some of my "Related tasks, Milestones, etc." became corrupt and i cannot for the life of me find a fix that works. 

    Once again, I can't believe that such obvious core functionality is such a problem for so many people using this platform. 

    I used to think that SharePoint would be a really great career path.  Now I think that anything but SharePoint is really the way to go..
    Monday, February 02, 2009 11:17 PM
  • >I used to think that SharePoint would be a really great career path.  Now I think that anything >but SharePoint is really the way to go..

    Using a free template as the reason for such a statement is wrong.

    The templates are there to provide **indications** of possible solutions. They are not intended to be used as the basis of a production system and are certainly not part of the official product.

    If you don't like the official product, fine, make your statement, but don't make it on the basis of a freebie.

    WSS FAQ sites: WSS 2.0: WSS 3.0 and MOSS 2007:
    Total list of WSS 3.0 and MOSS 2007 Books (including foreign language titles)
    Tuesday, February 03, 2009 4:53 AM
  • Actually, this is NOT a criticism of of the template but I in fact IS a complaint about the product based on the overall funtionality and difficulty of configuration.  The example is just that-an example of the larger, underlying issue.

    In fact- I have atempted to create new pages, that have similar functionality as the afforementioned DispForm.aspx, and I have had a heck of a time trying to get the "related DFWPs" to properly filter the results based on the project that is selected. A quick search through the MSDN archives will reveal that this is an issue for quite a few other folks and so far, I have not been able to find a solution that returns positive results. 

    I consider this to be unacceptable because to the casual eye is appears that this should be very easy to configure via the filter dialog box in the DFWP settings, when in reality it appears to require the user to make changes to the SelectParameter statement in code.  This process is concisely laid out by DrNash1111 in this thread but alas when I follow his guidance, I get nothing but errors, just as april_works2hard does.

    I would love to be able to retract my complaints and proclaim that my criticism was "unfair" but I still haven't seen any guidance that successfully rectifies this issue.  I am very aware of the fact that you are partially obligated to defend Microsoft in this forum but I believe that you would be more successful in doing this if you could actually help the users find solutions to their problems. 

    The bottom line is that while SharePoint offers much in the way of potential but there are a tremendous number of issues that plague this platform.  I have noticed that you are very active with the organization of this forum but I believe that Microsoft would be well served by throwing a lot more resources towards supporting the users, administrators and developers with more actual support and answers. IMO you have a diminishing opportunity to win over mainstream corporate America with this platoform.  Office is your cash cow and this could be the product that ties it all together and finally gets folks to LOVE you guys... But you are loosing ground because you fail to accept and properly address the real issues that you have. Up to  this point adoption has been strong.  In the future, attrition will be high unless you fully understand the serious nature of this problem.


    Tuesday, February 03, 2009 5:06 PM
  • I can't stop myself, I have to put in a few pennies...

    I just got off the phone with a customer and the Budgeting and Tracking Multiple Projects template is what most of the conversation was about. It fits his needs very well. Not perfectly, but for a freebie, very well.

    The reason it works so well for him is because of the tools we've written which take project data and synchronize it with SharePoint. Not only has Microsoft built a solid platform and provided tools for free, but you're starting to see ISVs like TeamDirection build on SharePoint and take it forward with more business solutions.

    Sounds healthy enough to me.

    If you want to see how easy we make working with the Budgeting and Tracking Multiple Projects template, you can visit our page.

    Best Regards,

    John Milan
    MOSS 2007 MVP
    Tuesday, February 03, 2009 11:07 PM
  • With all due respect, I think you guys are both missing the point.  I am not actually talking about Multi-Projects template!!!

    Despite the title of this post, the real subject matter of this thread is actually discussing how to create a custom page, similar to the DispForm.aspx in which I, and many other folks, want to add add DFWPs that pull content from related lists-based on the ListId that is passed from the original source list.

    This is SIMILAR to how this works on the DispForm.aspx page that is created in the Projects list of the Budgeting and Tracking Multiple Projects list. It is also similar to how it works in the IT Team Workspace AND the Project Tracking Workspace templates.

    I too have used the Budgeting and Tracking Multiple Projects template as the jumping off point for our main Projects site and I generally think that it is a fairly good template.  This has nothing to do with the fact that creating pages with functionality that is similar to the DispForm.aspx page in that list seems to be a lot more complicated and problematic than it should be. And it has nothing to do with the fact that Microsoft needs to throw a lot more resources into providing proper support for this product if they truly want it to succeed.

    If that wasn't in fact true, then the OP, Huxly and many other folks in other threads that discuss this subject matter would have had this question answered by one of the MS MVPs a long time ago...

    Wednesday, February 04, 2009 12:10 AM
  • SO true Fred, I have hit the same challenge as yourself, except that my headaches are automatically creating a doc repository and associated tasks for a new project, AND in making it easy for my users to view tasks BY PROJECT.  It's next to impossible, and as far as I can tell, there is no way at all to have a set of subtasks that comprise a task!  It's a great solution for making grocery lists, but not a real project management TeamSite as it should be.  All of that would be fine, if, to your point, you could Customize the template!!!!! 

    ~Pulling hair out

    Wednesday, January 19, 2011 7:10 PM
  • Hi Edward,

    I would like to know if we can get this "Budgeting and Tracking Multiple Projects Template " free for 2013 sharepoint version. I am doing the migration from Wss 3.0 to sharepoint 2013 and I am stuck of this template issue. I some how figured out the same template for 2010 version but I cant find for 2013 version. Please help me out in finding 2013 version of this template.


    Anvesh Tummala   

    Tuesday, June 30, 2015 3:26 PM