#1
|
|||
|
|||
Reporting Help
I have a difficult problem I need help with. The example below has been completely made up because the true detail is commercially sensitive, so bare with me. There might be holes in the example, but please don't pick it to pieces!
Let's assume we need to roll out new radios into different makes of car, and this will be done by engine type (OK, I know that the type of engine doesn't make a jot of difference to the radio...). Let's also assume this only applies to cars that have already been manufactured, i.e. this is a retro-fit. So we have: 1) Petrol A) VW Group: (i) VW: Week 1: 5 cars, week 2: 5 cars, week 3: 3 cars (ii) Skoda: Week 1: 4 cars, week 2: 4 cars, week 3: 3 cars (iii) Audi: Week 1: 5 cars, week 2: 3 cars, week 3: 3 cars B) Ford: Week 1: 2 cars, week 2: 2 cars, week 3: 1 car 1) Diesel A) Mercedes: Week 1: 6 cars, week 2: 5 cars, week 3: 4 car Resources aren't an issue because all car manufacturers have their own dedicated resources who will be available. I have set all this up in project, and can see all this on a gantt chart with no issue. The problem is the reporting I've been asked to create, which is: a) Show forecast by month, engine type and manufacturer (Presumably VW Group would also need to be shown as a whole and individually). b) Show total by manufacturer c) Show total by engine type d) Show a breakdown by individual weeks. e) I must also be able to compare actual with forecast for each. I've been using Project for a couple of weeks and have managed to learn quite a lot, but this is well beyond what I am capable of at the moment. Is anyone able to help? I have a background in Access VBA, so I'm not averse to using VBA should it be needed, but some help would be gratefully received. |
#2
|
|||
|
|||
You can do a fair amount through grouping. You'll need to set up the fields with the selections for Engine Type and Manufacturer. Add a few text fields and set up lookup fields to limit the entries.
Experiment with grouping to see if you can ge what you need. As far as actuals versus forecasts - you'll need a baseline to show what you had planned. |
#3
|
|||
|
|||
Quote:
|
#4
|
|||
|
|||
You're welcome. Feel free to post back with further questions.
|
#5
|
|||
|
|||
Ok. Here's the next question. I have been using VBA to update certain values in my tasks. It all works fine. What I have also tried to do is add a user form, and a couple of buttons to update. These also work.
However, one thing I thought I would mess around with (since it isn't really necessary) is to add a combobox that lists the task names. Once a task has been chosen a text box should show the current percent complete value, ready for an update. I have two problems: 1. I can't add a row source to the combobox. 2. I can't find a way to make the form available when project is opened. Any help will be gratefully received. |
#6
|
|||
|
|||
Hi,
I'm not sure I can help much as VBA is not in my wheel house. But I did find a post from someone (Jack Dahlgren) which may be of use: http://zo-d.com/blog/archives/progra...-userform.html I think his post will help with both questions. As an aside, if you are starting with new questions, best to post a new thread. It helps others to find things more quickly. |
#7
|
|||
|
|||
I've found a trick. Copy the microsoft Excel support. It seems that project is the poor relation, but it still works!
|
#8
|
|||
|
|||
Great. Glad you've found a solution. Be careful about taking the Excel analogy too far - Project is actually a closer cousin to Access (relational database).
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Cost Reporting 2013 | Steve. | Project | 7 | 05-14-2014 06:28 AM |
Reporting Machine Usage | EZRider | Excel | 0 | 12-17-2012 08:58 AM |
Resource Overallocation Reporting | Mutso | Project | 0 | 11-05-2010 12:27 PM |
Outlook reporting from mail merge?? | jondoyle24 | Outlook | 0 | 10-18-2010 06:44 AM |
Project Reporting | vickib1 | Project | 0 | 09-08-2010 03:11 AM |