Visual Reports in Project Pro 2007 SP1

[Robert]

Hello,
What is the meaning of the "Remaining Availability" field in the Resource
Usage report : it is always at zero while my resources have a lot of free
time. How is it calculated?

 

[JulieS]

Hello Robert,

The remaining availability field is calculated by Project based upon
the resource's working time as defined in his/her calendar, the
resource's max. units, and assigned work.

If you add the remaining availability field to the Resource Usage
view, do you see correct numbers?

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

 

[Robert]

Hi Julie,

In the Project Resource Usage view, I displayed all these fields:
- Actual work
- Baseline Work
- Remaining Work
- Work
- Work Availability
In Project, all these numbers seem correct.
When I do: Report | Visual Reports and create a new Template, in Excel 2007
the following fields stay blank:
- Baseline Work :blank
- Remaining Work : blank
- Work Availability: blank
The numbers in Work and in Actual Work are almost correct, while they fall
in the wrong week. The data in Excel are offset by 2 weeks : data of week 43
in Project arrives in week 41 in Excel...Etc...
So these reports are actually unusable. I'm using Project Pro 2007 with SP1
(but without Architecture Update)
Do you know if this mess is fixed in the AU?
Thanks for your help
Robert

 

[Robert]

Julie,
If I change the timephased unit: Month instead of Week, the values of Work
and Actual Work arrive in the right month column in Excel. The other fields
remain blank. An Excel expert explained me that Microsoft Excel does not
manage explicitly the Week unit. So what is the use of such a report?
Last question about Visual Reports before I throw them in the trash: How can
we build a Template and use it again one day after? I did not succeed in
giving a name and saving a template.
Thanks again for your help!
Robert

 

[JulieS]

Hi Robert,

I noticed some odd behavior and dates using the Visual Reports prior
to the Infrastructure Update. All appears fixed since then. My
first suggestion is to install the IU and test again.

Julie

 

[JulieS]

Hi Robert,

Without the Infrastructure update, I noticed oddities with dates --
however since the IU, the date issue appears resolved. I too saw
odd dates and could sometimes get the dates to correct themselves by
changing timescale (from Month to Week, or Week to Day) and
re-running the report.

I was able to step through creating a template without issue. Once
I selected the cube I wished to build the template on, I save the
file in Excel. I was prompted about whether I wished to clear the
existing data before saving the template. I can then show that
template in the list by selecting the option "Include report
templates from:" and selecting the correct file path.

I hope this helps.

Julie

 

[Robert]

Julie,
Thanks again. I'll do that.
Robert

Hi Robert,

Without the Infrastructure update, I noticed oddities with dates --
however since the IU, the date issue appears resolved. I too saw odd
dates and could sometimes get the dates to correct themselves by changing
timescale (from Month to Week, or Week to Day) and re-running the report.

I was able to step through creating a template without issue. Once I
selected the cube I wished to build the template on, I save the file in
Excel. I was prompted about whether I wished to clear the existing data
before saving the template. I can then show that template in the list by
selecting the option "Include report templates from:" and selecting the
correct file path.

I hope this helps.

Julie

 

[JulieS]

You're welcome Robert. Glad to have helped and thanks for the
feedback.
Julie