Solved

Creating a GNATT/ Timeline Report from a table of tasks

Posted on 2004-09-15
8
1,195 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
  • 4
  • 3
8 Comments
 
LVL 4

Expert Comment

by:nmilmine
Comment Utility
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
Comment Utility
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
Comment Utility
That was the one

Neil
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 1

Author Comment

by:Evolve2k
Comment Utility
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 125 total points
Comment Utility
Maybe the ship rotation schedule from
http://www.invisibleinc.com/download.cfm?filFilID=6

Neil
0
 
LVL 1

Author Comment

by:Evolve2k
Comment Utility
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
Comment Utility
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

743 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now