Need to creat a report in excel

[AllinOne]

I'm working on Project 2003 pro (stand alone)
I need to create an excel pivot-table report which gives me these
columns:

Year/quarter | resource | tasks |
On the "data" area I need to show work and cost

I can create this report on project 2007 (visual reports->budget work
report)
But I need to know if there is a possibility to make it also on the
2003.
I managed to create a report including all these fields except the
year/quarter on 2003.

Thanx

 

[Gérard Ducouret]

AllinOne,

Have you tried the Resource Usage view with a timescale in Year and Quarter?
You can add the Cost field besides the Work.
Hope this helps,

Gérard Ducouret

 

[AllinOne]

AllinOne,

Have you tried the Resource Usage view with a timescale in Year and Quarter?
You can add the Cost field besides the Work.
Hope this helps,

Gérard Ducouret

"AllinOne" <[email protected]> a écrit dans le message de (e-mail address removed)...







- Show quoted text -

How Can I export that view to excel except doing copy-paste?

 

[Gérard Ducouret]

"AllinOne" <[email protected]> a écrit dans le message de (e-mail address removed)...

AllinOne,

Have you tried the Resource Usage view with a timescale in Year and
Quarter?
You can add the Cost field besides the Work.
Hope this helps,

Gérard Ducouret

"AllinOne" <[email protected]> a écrit dans le message de (e-mail address removed)...







- Show quoted text -

How Can I export that view to excel except doing copy-paste?

You could try the "Analyse timephased data in Microsoft Excel" button in the
"Analysis" tool bar of 2003. But I'm afraid it will not do what you want ;-(

Gérard Ducouret