How to find out the Task wise Baseline duration for Datewise

S

Saragesh

Dear All

I need the details for my MPP details, when i baseline my task is 3 days
3*8=24, but i want that date wise my Baseline duration,
where to i get.

Thanks for your Effort.

Regards
 
R

Rod Gill

Sorry, I don't understand your question. For VBA
Activecell.Task.BaselineStart or Activecell.Task.Work/60 for hours of Work.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com
 
R

Rod Gill

Ah, that isn't a question, it's simply saying the version of project you
have. What problem do you have, what is it you want to do?

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com
 
S

Saragesh

Hi RG,

Project Server 2007,
My Query :

TASK St Dt Fin.Dt Duration
Task1 26/06/2009 29/06/2009 2Days
in MPP it will display only for 2days, where to i find out the Datewise
Baseline Duration
 
S

Saragesh

Hi
I know that, i will give the sample data, when i baseline after that publish
that date wise Baseline duration where will store.

now your clear or i will send the detail XL sheet.
give your mail ID
 
J

Jan De Messemaeker

Hi,

I still do not understand the question.
AFAIK, There is no such thing as a "date wise Baseline duration "
you can ent anything to jandemesATprom-ade.be

Greetings,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf
 
S

Saragesh

Hi

Task Name Duration Start Finish Work
Baseline Start Baseline Finish Baseline Duration
Baseline Work Resource Names
Task1 2 days 26/06/09 9:00 AM 30/06/09 9:00 AM 16 hrs 26/06/09 9:00
AM 30/06/09 9:00 AM 2 days 16 hrs R1

Just copy the notepad, wrap the test

this is my MPP task line, when published it will store in the Some of the
table correct, but here displayed in the MPP Baseline work is 16hrs,
the same task datewise stored in some where, WHERE IT is STORED.
still you're not clear, give your mail id : i will forward my MPP
 
J

Jan De Messemaeker

Hi,

You absolutely want to use the word datewise, which is not in the English
dictionary, so I'll forget about it.
Do you mean you want durations in hours instead of days?
That is through Tools, Macro, Macros, Format_Duration, Run.

Hope this helps,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf
 
R

Rod Gill

They mean date wise as in from a date perspective. They are also referring
to emails, not Project.

I'm afraid both Jan and I have no idea what you mean or what you want to
achieve. There are baseline dates (start and finish), baseline duration,
cost and work but nothing else.



--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com
 
S

Saragesh

Hi,

When i want to generate the report for my resource wise Planned and Actual
hrs report for Resource utilization details.

we don't want to probable planned hrs, only baseline duration against Actual
hrs
that details stored in the DB(ProjectServer_Reporting) but Table details i
need.
 
R

Rod Gill

Ok, Download the Software Development Kit (SDK) for Project Server from
microsoft.com and look at the FILE pj12ReportingDB.chm

This will show you the full schema for the reporting db. I recommend using
the built in views such as dbo.MSP_EpmTask_UserView because all Views ending
with _userview automatically have relevant custom fields added to them.



--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com
 
S

Saragesh

ok, thanks
already i have we used the same.

dbo.MSP_EpmTask_UserView, showing TaskDuration columns. consolidated hrs
only, for ex. task is days it will displayed 16hrs only, two days breakup
details i need.
that's what i mentioned very clearly DATE WISE baseline duration.

if i am trouble you for lot, Shall i close this call.
 
R

Rod Gill

So what about the dbo.MSP_EpmTaskByDay_UserView View?

I'm afraid we are still stuck on DATE WISE baseline duration as this makes
no sense from an English or Microsoft Project perspective!

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com
 
R

Rod Gill

Date wise is completely meaningless English in this context! "Date wise
Status" means nothing in English except possibly status change over time
(duration does not vary over time, the Task is either in progress or it
isn't unless you have confused Duration with Work. Work does vary over
time). The presenter must have explained what thy mean because Jan and I
have no idea what you mean.

How about you explain to someone else in your own language what you want and
get them to translate because your needs are getting lost in your
translation.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing Baseline dates due to snow days 0
Receiving unexpected Duration 0
Modify the gantt chart view in project center (WPA) (MS Project 2010) 0
Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0
Adding to Baseline data 4
Weighted % Complete calculation 1
how to transfert data from baseline to work? 3
Logic to loop through the MPP 3

Top