Report on All Projects

[John]

I'm running Project Server 2002 with approximately 150 projects published.
I'm being asked to generate a weekly report showing the list of projects,
start/end dates, and various other pieces of information. One of the
advantages of doing this in Project Professional 2002, is that I can utilize
the graphical indicators (all of our managers seem to like that).

I've been doing ok creating a "master" project plan and saving it locally
onto my desktop. (I don't allow master plans on my project server.)
However, 150 projects has become too many for me to determine if there are
updates to the plan, then remove it from my master plan, the re-add the
project to my master plan.

Is there a way to "insert all" projects on the server to a plan?

(In effect, I'm trying to create the Project Center view but in printable
form for a weekly management meeting. I know the simplest thing to do would
be to have management look at the project center view, but we haven't
migrated that far in our processes, so I need this as something in the
interim.)

Thanks,
John

 

[Gary L. Chefetz \(MVP\)]

John,

If you can get all the information you're looking for designed into a
Project Center view, then producing a report from this fairly easy. I don't
suppose upgrading to 2003 is an option? This is very easy to do in 2003
directly from the web. In 2002, you need to display the view, select the
entire grid by clicking in the select all cell, the click Ctrl+C to copy.
Open Excel an paste into an Excel worksheet. Format to your liking and
print.

--

Gary L. Chefetz, MVP
"We wrote the book on Project Server
http://www.msprojectexperts.com

-

 

[John]

We're in the process of acquiring the licenses for 2003. Until then, I'm
stuck using what we have.
I would like to use copy and paste into excel, but it doesn't copy over the
red, yellow, green, indicator light.
Any other suggestions?

 

[Gary L. Chefetz \(MVP\)]

John:

It copies the values, not the graphics. I think with a little effort, you
can get what you ultimately want. Even using 2003, the graphics aren't
printable.

--

Gary L. Chefetz, MVP
"We wrote the book on Project Server
http://www.msprojectexperts.com

-

 

[John]

That's not so good. I was hoping they would be printable. I guess you're
right - I'll have to play exporting to Excel. Not too long ago, I heard
someone say that you could have a formula that would color an entire cell
red or green based on the value. I'll give that a shot a see what happens.

BTW, thanks for your help. Without you and some of the others in here, I
wouldn't have understood half of the issues that popup.

 

[Vadim Bogdanov]

Hi John,

you may do it easily with OLAP reports in Portfolio analyzer.
To add project level fields just use our OLAP extender:
http://make.bogdanov-associates.com/eng.asp?rubr_id=476

That might be a very simple way,

regards,
Vadim