Problems generating custom reports

[Dennis Palmiero]

I have approximately 25 projects that need to be interrogated for specific
tasks (identified by Custom Outline codes). I identify which Projects I need
to include for analysis in a Master Project using PWA which opens them using
Project Professional and indicates all the imbedded Projects as linked files.
The deciding factor for display would be the specific task date (from a Task
Calendar) for a particular project. If it falls in the Week of date range it
is displayed. There are multiple tasks and multiple projects that will be
included.

I need to generate a custom view/report (or what ever mechanism) that
displays the following format:

Week of Month, day
Task name A
Linked project 1
Linked project 3
Linked Project x

Task Name B
Linked project 3
Linked project 5
Linked Project x


I’m trying to figure out the best approach to present the finished product
in a custom report format (not the standard report print output) so I also
need to utilize some sort of output format tool (export into Excel?).

I have tried many combinations of filters/views/reports with combinations of
custom fields and outline codes and have not been able to come up with a
credible report.

The primary problem I’m having is displaying each linked project name in the
report.
Any help you can give me to set me in the right direction to develop a
procedure to get this and any repetitive report completed would be greatly
appreciated.

 

[Gary L. Chefetz [MVP]]

Dennis:

You should post his question at microsoft.office.project.developer where
someone can get you pointed in the right direction using VBA

 

[Dennis Palmiero]

Thanks Gary

I was hoping this could be done by using the builtin
fileds/views/filters/reports etc.
I don't really need a coding challenge anyway, I reposted it in the
developers forum.
--
Dennis Palmiero
MCT, MCSE, MCSA, MCP+I, etc...

Dennis:

You should post his question at microsoft.office.project.developer where
someone can get you pointed in the right direction using VBA