?
Solved

Creating a GNATT/ Timeline Report from a table of tasks

Posted on 2004-09-15
8
Medium Priority
?
1,231 Views
Last Modified: 2010-04-14
I have a task table in my database where users can record something similar to the following:

Task   StartDate   Deadline     DateDone
A          1/10/04     15/10/04  
B          8/10/04     25/10/04
C        20/10/04     30/10/04
D        25/10/04       5/11/04

What I want to be able to do is create a GNATT diagram as a report in Access2k based on the above data in the table.
(see: http://www.smartdraw.com/resources/centers/gantt/tutorial1.htm for more info on GNATT diagrams)

Just to give you a rought idea it should look something like this:

Task    Week1   Week2  Week3  Week4  Week5  Week6  Week7  Week8 Week9 Week10
A            ---------------------
B                        --------------------
C                           ------------------------------------------------
D                                                ------------------------------------------------------------

Basically I wanted to take the fairly static looking table and let people view their tasks on a timeline basis.

Any ideas how I can achieve this?

My ideas so far
-----------------
Im not imagining a very fancy result, all I thought would be that the report would basically be one big grid with each column having a heading based on the week ending date.
Each box in the grid would either be empty (white) or filled in (black) depending on whether that particular week fell within the StartDate and Deadline for the task in that row.

Any ideas guys?
Also if you have a totally different approach let me know.  
0
Comment
Question by:Evolve2k
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
8 Comments
 
LVL 4

Expert Comment

by:nmilmine
ID: 12071562
I have a demo I downloaded some time ago which was made by Michael Blake.

Would be happy to send to you

Neil
0
 
LVL 1

Author Comment

by:Evolve2k
ID: 12098049
That's ok nmilmine, actually I did a little detective work myself once u mentioned the name of the author and found a Michael Blake download called TimeLine.zip at the following site, http://www.weascend.com/Downloads.htm . Hopefully if that's the same as you were trying to send then everyone got access to it.

Let me know if this is the file?

0
 
LVL 4

Expert Comment

by:nmilmine
ID: 12099171
That was the one

Neil
0
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
LVL 1

Author Comment

by:Evolve2k
ID: 12099234
Ok I tested out the file, visually he's offering an example, but it doesn't seem to be dynamic based on the data?

I think an approach with grids which are either black or white would be more visually effective as well as hopefully easier to implement, but Im not that fussy, any approach is better than none.

Any ideas with getting the report dynamic from the data?
0
 
LVL 4

Accepted Solution

by:
nmilmine earned 500 total points
ID: 12099347
Maybe the ship rotation schedule from
http://www.invisibleinc.com/download.cfm?filFilID=6

Neil
0
 
LVL 1

Author Comment

by:Evolve2k
ID: 12100142
Yep, The ship rotation report is exactly the kind of thing Im looking for.
I can see how 'Vessel' could be replaced with Task/Project. I like how it does colour bars also.  

Ive had a bit of a look at the tables, reports and code. Still getting a handle on how it all works, Ill let you know how I go.
0
 
LVL 1

Author Comment

by:Evolve2k
ID: 12197653
The ship rotation report was very easly converted into a very fancy live GNATT chart.

Perfect and simple answer.

Thanks so much nmilmine


Note for those looking to achieve this it works as follows:
Inserts one big square box which it calls timeline. Take Timeline / 365 and it works out the length of a 'day' (called a tupel in the example). Then for each Task EndTime-StartTime gives number of days. Number of days x length of day gives the system the length it needs to size the task box for that task exaclty the right lenght accurate to the day and it uses that orginal timeline box to know the bounds of the graphical area.

0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question