• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1257
  • Last Modified:

Creating a GNATT/ Timeline Report from a table of tasks

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
Evolve2k
Asked:
Evolve2k
  • 4
  • 3
1 Solution
 
nmilmineCommented:
I have a demo I downloaded some time ago which was made by Michael Blake.

Would be happy to send to you

Neil
0
 
Evolve2kAuthor Commented:
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
 
nmilmineCommented:
That was the one

Neil
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

 
Evolve2kAuthor Commented:
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
 
nmilmineCommented:
Maybe the ship rotation schedule from
http://www.invisibleinc.com/download.cfm?filFilID=6

Neil
0
 
Evolve2kAuthor Commented:
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
 
Evolve2kAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now