Solved

Creating a GNATT/ Timeline Report from a table of tasks

Posted on 2004-09-15
8
1,214 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
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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 125 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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
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 …
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

756 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