Microsoft Office Forums Reporting Help

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-03-2016, 08:31 AM
ImRubbishatThis ImRubbishatThis is offline Reporting Help Windows 7 64bit Reporting Help Office 2013
Novice
Reporting Help
 
Join Date: May 2016
Posts: 4
ImRubbishatThis is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 05-08-2016, 06:33 PM
JulieS JulieS is offline Reporting Help Windows 7 64bit Reporting Help Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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.
Reply With Quote
  #3  
Old 05-09-2016, 12:51 AM
ImRubbishatThis ImRubbishatThis is offline Reporting Help Windows 7 64bit Reporting Help Office 2013
Novice
Reporting Help
 
Join Date: May 2016
Posts: 4
ImRubbishatThis is on a distinguished road
Default

Quote:
Originally Posted by JulieS View Post
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.
Thanks for that. I'm still playing! It seems to be sorting itself out...
Reply With Quote
  #4  
Old 05-09-2016, 04:36 AM
JulieS JulieS is offline Reporting Help Windows 7 64bit Reporting Help Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

You're welcome. Feel free to post back with further questions.
Reply With Quote
  #5  
Old 05-12-2016, 06:52 AM
ImRubbishatThis ImRubbishatThis is offline Reporting Help Windows 7 64bit Reporting Help Office 2013
Novice
Reporting Help
 
Join Date: May 2016
Posts: 4
ImRubbishatThis is on a distinguished road
Default

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.
Reply With Quote
  #6  
Old 05-15-2016, 07:55 AM
JulieS JulieS is offline Reporting Help Windows 7 64bit Reporting Help Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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.
Reply With Quote
  #7  
Old 05-16-2016, 01:02 AM
ImRubbishatThis ImRubbishatThis is offline Reporting Help Windows 7 64bit Reporting Help Office 2013
Novice
Reporting Help
 
Join Date: May 2016
Posts: 4
ImRubbishatThis is on a distinguished road
Default

I've found a trick. Copy the microsoft Excel support. It seems that project is the poor relation, but it still works!
Reply With Quote
  #8  
Old 05-18-2016, 05:32 AM
JulieS JulieS is offline Reporting Help Windows 7 64bit Reporting Help Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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).
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Reporting Help 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


All times are GMT -7. The time now is 05:14 PM.


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