Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-24-2014, 08:00 AM
cergon cergon is offline Resource Usage view does not correctly export to a Visual Report Windows Vista Resource Usage view does not correctly export to a Visual Report Office 2007
Novice
Resource Usage view does not correctly export to a Visual Report
 
Join Date: Apr 2014
Posts: 2
cergon is on a distinguished road
Default Resource Usage view does not correctly export to a Visual Report

Hi all, hope somebody can help with this as i just cant figure out why this isn't working!

I'm using the resource usage view in project to allocate effort to individuals assigned to tasks. I have the view set to show week commencing dates and enter data from 0.5 to 5 days per week for each task.

I've created a custom Visual Report template based on the assignment usage data type. I create the usage data at the week level and select 'work' as the parameter to be exported.

when viewing the pivot table in Excel i can display by week number however the figures don't match what was entered in the Resource Usage view in Project. For Example i have a task with the following effort allocation:

Project:


Week Commencing 14/04 - 3 days
Week Commencing 21/04 - 2.5 days
Week Commencing 28/04 - 2 days

Visual Report:
Week Commencing 14/04 (Week 16) - 2 days
Week Commencing 21/04 (Week 17) - 0 days
Week Commencing 28/04 (Week 18) - 0 days

I don't understand what's going on, any help would be greatly appreciated!
Reply With Quote
  #2  
Old 04-24-2014, 05:15 PM
JulieS JulieS is offline Resource Usage view does not correctly export to a Visual Report Windows 7 64bit Resource Usage view does not correctly export to a Visual Report Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

What release of Project? What service pack do you have applied? Project 2007 is up to SP-3, Project 2010 is up to SP-2, and Project 2013 is up to SP-1.

When you say you enter "data from .5 to 5 days per week for each task" - I assume you are entering work in the assignment row in the Resource Usage view? If you zoom in do you see the hours per day spread as expected? If I enter work per week - unless I am using Fixed Duration tasks, the task duration shortens when I enter 4 hours (.5 days) of work on a task in a week.

In testing with Project 2010 and manually entering the work on the assignment line - the weekly values match the default Baseline Work Visual Report.
Reply With Quote
  #3  
Old 04-25-2014, 03:37 AM
cergon cergon is offline Resource Usage view does not correctly export to a Visual Report Windows Vista Resource Usage view does not correctly export to a Visual Report Office 2007
Novice
Resource Usage view does not correctly export to a Visual Report
 
Join Date: Apr 2014
Posts: 2
cergon is on a distinguished road
Default

Quote:
Originally Posted by JulieS View Post
What release of Project? What service pack do you have applied? Project 2007 is up to SP-3, Project 2010 is up to SP-2, and Project 2013 is up to SP-1.
It's Project 2007, SP1. I'll try and get IT to patch SP3 and see if that helps!

Quote:
Originally Posted by JulieS View Post
When you say you enter "data from .5 to 5 days per week for each task" - I assume you are entering work in the assignment row in the Resource Usage view? If you zoom in do you see the hours per day spread as expected? If I enter work per week - unless I am using Fixed Duration tasks, the task duration shortens when I enter 4 hours (.5 days) of work on a task in a week.
That's correct, i am entering work in the assignment row in the resource usage view. When i zoom in then i see the hrs spread as expected.

Quote:
Originally Posted by JulieS View Post
In testing with Project 2010 and manually entering the work on the assignment line - the weekly values match the default Baseline Work Visual Report.
That's interesting, if SP3 doesn't help then i'll try to get an upgrade to Project 2010.

Thanks again for your help Julie, much appreciated. Will keep the group posted on progress.
Reply With Quote
  #4  
Old 04-25-2014, 06:10 AM
JulieS JulieS is offline Resource Usage view does not correctly export to a Visual Report Windows 7 64bit Resource Usage view does not correctly export to a Visual Report Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Definitely start with SP-3. Let us know how you get on.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Resource Usage view does not correctly export to a Visual Report Problem creating visual report shird Project 2 03-18-2019 03:44 AM
Resource Usage view does not correctly export to a Visual Report Exporting Resource Usage data to Excel samg54 Project 1 08-02-2013 05:28 AM
Resource Usage view does not correctly export to a Visual Report project 2010 resource usage runejors Project 1 04-04-2013 05:55 AM
Resource Usage view does not correctly export to a Visual Report MS Project - Resource usage printout scrinmemphis Project 1 02-22-2013 02:30 PM
Resource Usage sheet - options Andy Bain Project 1 11-05-2010 12:42 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 02:25 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft