Looking to create Milestone Reporting

[Adam Clark]

I am looking to create a specific milestone report that will append a SQL
reporting Project Status Report, but unfortunalty I am at a loss on how to
get the information together to create the report.

Currently I have created an Enterprise Text Field called 'Milestone
Reporting' will values from 1 - 9. These values are used in the report.

I have identified the tables where the data is stored
MSP_VIEW_PROJ_TASKS_STD and MSP_TEXT_FIELDS, however I cannot find the link
between these two tables as there is no reportable dependancies.

So with that information I am wondering if anyone has had any experience
with this type of an issue and how you approached / resolved the issue?

Many Thanks

Adam Clark.

 

[TGG]

Adam,

This article on Gord Schmidt's blog might give you some insights as to where
they might be. It is specific to enterprise outline codes, but he has some
good resources listed.
http://www.domorethanmanage.com/articles/2005/01/31/SQLtoreturnanOutlineCodeV.html

TGG
blog: http://spaces.msn.com/members/evildoctorporkchop

 

[Adam Clark]

Cheers!

Adam,

This article on Gord Schmidt's blog might give you some insights as to
where
they might be. It is specific to enterprise outline codes, but he has
some
good resources listed.
http://www.domorethanmanage.com/articles/2005/01/31/SQLtoreturnanOutlineCodeV.html

TGG
blog: http://spaces.msn.com/members/evildoctorporkchop

 

[Reino Schneidergros]

Hi Adam,

have you considered OLAP report with tasks marked as milestones?

You may use this tool
(http://www.bogdanov-associates.com/eng.asp?rubr_id=484) to generate this
sort of reports.

Regards,
Reino