VBA, Adding Predecessor information in Gantt view

Adding Predecessor information in Gantt view

Author	Message
Bob Masse #1 / 9	Adding Predecessor information in Gantt view Am using pjgrid2.ocx in asp application. I can correctly pass all info to display gantt task start stop etc information in right pane except for the predecessor info as appears in MSP. i.e. I am not displaying the lines and arrows associated with the predecessor field. Can anyone tell me what property or method is used/modified to add this capability? A code snipet would be great. Many Thanks, Bob Massey
Sat, 10 Sep 2005 10:52:33 GMT

Jack D #2 / 9	Adding Predecessor information in Gantt view Quote: > Am using pjgrid2.ocx in asp application. I can correctly pass all info to > display gantt task start stop etc information in right pane except for the > predecessor info as appears in MSP. i.e. I am not displaying the lines and > arrows associated with the predecessor field. > Can anyone tell me what property or method is used/modified to add this > capability? A code snipet would be great. > Many Thanks, > Bob Massey I am not certain about pjgrid2, but the pjgrid which was part of Project Central did not have this capability. I'm sorry I am not familiar enough with Project Server to tell you exactly where to look, but if this capability exists then it is likely to be used somewhere. Try searching the code for where pjgrid is called and see if you can find an example. -- Please try to keep replies in this group. I do check e-mail, but only infrequently. For Macros and other things check http://masamiki.com/project -Jack Dahlgren, Project MVP +++++++++++++++++++
Sun, 11 Sep 2005 03:03:03 GMT

Bob Masse #3 / 9	Adding Predecessor information in Gantt view Thanks Jack, Yes this is new to XP (2002) version of the control. I believe it references either the Predecessor or Sucessor columns but not sure how to assign. There is a property called SuccessorBinding but not quite sure if this is relavent and if so how it gets set. I am binding the control to another data source so need to make explicit references. Will keep digging. Thanks for your time... Bob
Sun, 11 Sep 2005 05:08:26 GMT

Bob Masse #4 / 9	Adding Predecessor information in Gantt view In case anyone else is interested I was able to get the information from Microsoft. Dependency information is passed to the grid via the SuccessorBinding property. In essense you pass the property a recordset which contains the task id successor task id and sucessor type FS, SS, etc. This functionality was added in P10. If anyone wants more specifics please don't hesitate to contact me... Quote: > Am using pjgrid2.ocx in asp application. I can correctly pass all info to > display gantt task start stop etc information in right pane except for the > predecessor info as appears in MSP. i.e. I am not displaying the lines and > arrows associated with the predecessor field. > Can anyone tell me what property or method is used/modified to add this > capability? A code snipet would be great. > Many Thanks, > Bob Massey
Mon, 19 Sep 2005 04:02:04 GMT

Mark Durrenberge #5 / 9	Adding Predecessor information in Gantt view Bob, thanks for passing this along. I am curious. Are you creating your own Gantt charts? I have a Graphic I've wanted to create using Project's Gantt Chart Engine What can you tell me? Thanks, Mark Quote: > In case anyone else is interested I was able to get the information from > Microsoft. Dependency information is passed to the grid via the > SuccessorBinding property. In essense you pass the property a recordset > which contains the task id successor task id and sucessor type FS, SS, etc. > This functionality was added in P10. If anyone wants more specifics please > don't hesitate to contact me... > > Am using pjgrid2.ocx in asp application. I can correctly pass all info to > > display gantt task start stop etc information in right pane except for the > > predecessor info as appears in MSP. i.e. I am not displaying the lines and > > arrows associated with the predecessor field. > > Can anyone tell me what property or method is used/modified to add this > > capability? A code snipet would be great. > > Many Thanks, > > Bob Massey
Mon, 19 Sep 2005 04:38:28 GMT

Bob Masse #6 / 9	Adding Predecessor information in Gantt view Mark, What we are doing is taking the pjgrid2.ocx as a standalone and programatically feeding it data from a non MSP data source. Works fine but could not get the predecessor/successor to work until I found out how the successorbinding property worked. MS has a knowledgebase article entitiled "Using Microsoft Project Central Controls with Another Data Source". Unfortunately it predates P10 so it doesn't have some of the newer properties explained such as successor binding, but it does explain the basic get/set operations you would need to pull the data. Am now working on critical path display. Hope this helps... Bob Quote: > Bob, thanks for passing this along. I am curious. Are you creating your own > Gantt charts? I have a Graphic I've wanted to create using Project's Gantt > Chart Engine > What can you tell me? > Thanks, > Mark
Tue, 20 Sep 2005 09:56:35 GMT

Jack D #7 / 9	Adding Predecessor information in Gantt view Bob, Can you share any of this information or a snippet of code? I could put a page together on my web site with it and proper attribution to you if you have the time to post it. -Jack Quote: > Mark, > What we are doing is taking the pjgrid2.ocx as a standalone and > programatically feeding it data from a non MSP data source. Works fine but > could not get the predecessor/successor to work until I found out how the > successorbinding property worked. MS has a knowledgebase article entitiled > "Using Microsoft Project Central Controls with Another Data Source". > Unfortunately it predates P10 so it doesn't have some of the newer > properties explained such as successor binding, but it does explain the > basic get/set operations you would need to pull the data. > Am now working on critical path display. Hope this helps... > Bob >> Bob, thanks for passing this along. I am curious. Are you creating your >> own Gantt charts? I have a Graphic I've wanted to create using >> Project's Gantt Chart Engine >> What can you tell me? >> Thanks, >> Mark
Wed, 21 Sep 2005 08:06:11 GMT

Bob Masse #8 / 9	Adding Predecessor information in Gantt view Jack, Sure thing. I'll try to get it to you later this week. If I forget please don't hesitate to remind me. Bob Quote: > Bob, > Can you share any of this information or a snippet of code? I could put a > page together on my web site with it and proper attribution to you if you > have the time to post it. > -Jack > > Mark, > > What we are doing is taking the pjgrid2.ocx as a standalone and > > programatically feeding it data from a non MSP data source. Works fine but > > could not get the predecessor/successor to work until I found out how the > > successorbinding property worked. MS has a knowledgebase article entitiled > > "Using Microsoft Project Central Controls with Another Data Source". > > Unfortunately it predates P10 so it doesn't have some of the newer > > properties explained such as successor binding, but it does explain the > > basic get/set operations you would need to pull the data. > > Am now working on critical path display. Hope this helps... > > Bob > >> Bob, thanks for passing this along. I am curious. Are you creating your > >> own Gantt charts? I have a Graphic I've wanted to create using > >> Project's Gantt Chart Engine > >> What can you tell me? > >> Thanks, > >> Mark
Sat, 24 Sep 2005 08:40:40 GMT

Bob Masse #9 / 9	Adding Predecessor information in Gantt view From the better late than never department. Here is the info on using the SuccessorBinding property. It comes directly from Microsoft. The following info was received directly from Microsoft. It applies to versions P10 and P11. Do not know how far back it goes. In the grid control there is a property labeled SuccessorBinding. Note that all references are to successor data. There is no reverse property PredecessorBinding. From Microsoft: "You'll need to create an ADO recordset with the following fields and pass it to SuccessorBinding. TaskUniqueID - ID of task SuccessorTaskUniqueID - ID of the successor task SuccessorType - Link type: Finish to Finish = 0 Finish to Start = 1 Strat to Finish = 2 Start to Start = 3 The main recordset (one that is passed to Binding property) will also need to contain a field called "TaskUniqueID" with values that match the ID's in the SuccessorBinding recordset. Please note that the column names for the links table are essential, as is using TaskUniqueID in the Assignments table, it's what links everything together. " Hope this helps. With this info we were able to get it working without any additional problems. Quote: > Jack, > Sure thing. I'll try to get it to you later this week. If I forget please > don't hesitate to remind me. > Bob > > Bob, > > Can you share any of this information or a snippet of code? I could put a > > page together on my web site with it and proper attribution to you if you > > have the time to post it. > > -Jack > > > Mark, > > > What we are doing is taking the pjgrid2.ocx as a standalone and > > > programatically feeding it data from a non MSP data source. Works fine > but > > > could not get the predecessor/successor to work until I found out how > the > > > successorbinding property worked. MS has a knowledgebase article > entitiled > > > "Using Microsoft Project Central Controls with Another Data Source". > > > Unfortunately it predates P10 so it doesn't have some of the newer > > > properties explained such as successor binding, but it does explain the > > > basic get/set operations you would need to pull the data. > > > Am now working on critical path display. Hope this helps... > > > Bob > > >> Bob, thanks for passing this along. I am curious. Are you creating your > > >> own Gantt charts? I have a Graphic I've wanted to create using > > >> Project's Gantt Chart Engine > > >> What can you tell me? > > >> Thanks, > > >> Mark
Tue, 29 Nov 2005 03:33:04 GMT

Page 1 of 1

[ 9 post ]