By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,676 Members | 1,636 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,676 IT Pros & Developers. It's quick & easy.

How would I build a Graphical Timeline

P: n/a
Hello-
I'm interested in building a graphical timeline for a series of tasks that
are stored in a SQL Server 2000 database. The tasks reside within a table.
We also have a table to track the history and date of status changes. Some
of the status flags are as follows:
1 - In Progress.
2 - Awaiting Info.
3 - On review server.

For each task, using ASP or ASP.Net, I would like to be able to display a
graphical timeline for each task, with the status changes denoted for a
given date range.

Does anyone have any ideas on the best approach for this task?

Thanks alot!
Chris
Jul 19 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
TJS
try this:

http://www.aspkey.net/aspkey/_store/...projectdisplay
"Cobb" <cc*****@yahoo.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
Hello-
I'm interested in building a graphical timeline for a series of tasks that
are stored in a SQL Server 2000 database. The tasks reside within a table.
We also have a table to track the history and date of status changes. Some
of the status flags are as follows:
1 - In Progress.
2 - Awaiting Info.
3 - On review server.

For each task, using ASP or ASP.Net, I would like to be able to display a
graphical timeline for each task, with the status changes denoted for a
given date range.

Does anyone have any ideas on the best approach for this task?

Thanks alot!
Chris

Jul 19 '05 #2

P: n/a
On Mon, 20 Oct 2003 10:02:36 -0400, "Cobb" <cc*****@yahoo.com> wrote:
Hello-
I'm interested in building a graphical timeline for a series of tasks that
are stored in a SQL Server 2000 database. The tasks reside within a table.
We also have a table to track the history and date of status changes. Some
of the status flags are as follows:
1 - In Progress.
2 - Awaiting Info.
3 - On review server.

For each task, using ASP or ASP.Net, I would like to be able to display a
graphical timeline for each task, with the status changes denoted for a
given date range.


Depending on your audience and the level of sophistication you have,
you can try either a normal charting tool, or if you just want a
horizontal or vertical bar chart with different colors, you could do
it with a table. Assuming a horizontal bar, if you can calculate a
percent of the total time to display, this would be the width of a td
element in a table row. You would need to determine beforehand how
many changes were made in the timeframe...

<table width=400 cellspacing=0 cellpadding=0>
<tr>
<td width=10% bgcolor="red">&nbsp;</td>
<td width=40% bgcolor="yellow">&nbsp;</td>
<td bgcolor="green">nbsp;</td>
</tr>
</table>

This would show a horizontal bar 400 pixels wide with 10% in red, 40%
in yellow and the rest (50%) in green. I would suggest using a style
sheet instead of coding in the colors. You could also use background
images instead of the background colors. This way, you could use
graphics, shading, etc. Depending on your skills with HTML and Table
layout, the sky is "almost" your limit :)
Jul 19 '05 #3

P: n/a
Thanks a bunch!

Chris
"TJS" <no****@here.com> wrote in message
news:vp************@corp.supernews.com...
try this:

http://www.aspkey.net/aspkey/_store/...projectdisplay
"Cobb" <cc*****@yahoo.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
Hello-
I'm interested in building a graphical timeline for a series of tasks that are stored in a SQL Server 2000 database. The tasks reside within a table. We also have a table to track the history and date of status changes. Some of the status flags are as follows:
1 - In Progress.
2 - Awaiting Info.
3 - On review server.

For each task, using ASP or ASP.Net, I would like to be able to display a graphical timeline for each task, with the status changes denoted for a
given date range.

Does anyone have any ideas on the best approach for this task?

Thanks alot!
Chris


Jul 19 '05 #4

P: n/a
Thanks alot, I appreciate the tip. This is the direction I'm pursuing.

Chris
"Dan Brussee" <db******@NOSPAMnc.rr.com> wrote in message
news:g6********************************@4ax.com...
On Mon, 20 Oct 2003 10:02:36 -0400, "Cobb" <cc*****@yahoo.com> wrote:
Hello-
I'm interested in building a graphical timeline for a series of tasks thatare stored in a SQL Server 2000 database. The tasks reside within a table.We also have a table to track the history and date of status changes. Someof the status flags are as follows:
1 - In Progress.
2 - Awaiting Info.
3 - On review server.

For each task, using ASP or ASP.Net, I would like to be able to display a
graphical timeline for each task, with the status changes denoted for a
given date range.


Depending on your audience and the level of sophistication you have,
you can try either a normal charting tool, or if you just want a
horizontal or vertical bar chart with different colors, you could do
it with a table. Assuming a horizontal bar, if you can calculate a
percent of the total time to display, this would be the width of a td
element in a table row. You would need to determine beforehand how
many changes were made in the timeframe...

<table width=400 cellspacing=0 cellpadding=0>
<tr>
<td width=10% bgcolor="red">&nbsp;</td>
<td width=40% bgcolor="yellow">&nbsp;</td>
<td bgcolor="green">nbsp;</td>
</tr>
</table>

This would show a horizontal bar 400 pixels wide with 10% in red, 40%
in yellow and the rest (50%) in green. I would suggest using a style
sheet instead of coding in the colors. You could also use background
images instead of the background colors. This way, you could use
graphics, shading, etc. Depending on your skills with HTML and Table
layout, the sky is "almost" your limit :)

Jul 19 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.