Project 2003 reporting experiences

[Nock]

I am in the process of determining the appropriate reporting tool for our
Program Office. We have approximately 25 PM's who report back weekly to a
Program Manager.

Presently, PM's are expected to manually create large, rather cumbersome
Excel spreadsheet (risks, issues, dependancies, milestones, costs & inserted
excel graphs) each week. This is obviously a fairly manually intensive task
and I'd like to be able to automate the entire process - a big ask I know.

Has anyone used SQL reporting services, the Proj Prof XML Reporting Wizard,
cubes, RDL Components, SQL Queries, Crystal Reports, .NET or combinations of
these to produce reports of this nature?

I'm a little overwhelmed by the sheer volume of possibilities! Any feedback
is most welcome!

Many, many thanks,

Nock

 

[Rod Gill]

I've written Excel VBA macros to download data from a Project Server
database that in 5 seconds (500mS+ latency!) filled in data in 5 worksheets
for current tasks, milestones, Issues and Risks etc. It's fairly
straightforward and was very popular with the PM's.

Personally I love Excel as a reporting tool. I created Views for every
worksheet in SQL Server then downloaded the Views to Excel.

 

[Nock]

Thanks Rod - I appreciate your feedback.

Would you consider this task (as I outlined previously) difficult for
someone with only basic visual basic scripting knowledge, more importantly
would I need high VBA skill levels to take this on?

Thankyou.

Nick