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"> </td>
<td width=40% bgcolor="yellow"> </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 :)
