Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Creating a GNATT/ Timeline Report from a table of tasks

Posted on 2004-09-15
8
Medium Priority
?
1,239 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

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

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

604 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