How would I build a Graphical Timeline

[Cobb]

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

[TJS]

try this:

[url]http://www.aspkey.net/aspkey/_store/asp/store.asp#projectdisplay[/url]


"Cobb" <ccoyusa@yahoo.com> wrote in message
news:%23M8ulKxlDHA.1656@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
>
>

[Dan Brussee]

On Mon, 20 Oct 2003 10:02:36 -0400, "Cobb" <ccoyusa@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 :)

[Cobb]

Thanks a bunch!

Chris


"TJS" <nospam@here.com> wrote in message
news:vp8hsgrdua226f@corp.supernews.com...

> try this:
>
> [url]http://www.aspkey.net/aspkey/_store/asp/store.asp#projectdisplay[/url]
>
>
> "Cobb" <ccoyusa@yahoo.com> wrote in message
> news:%23M8ulKxlDHA.1656@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
> >
> >

>
>

[Cobb]

Thanks alot, I appreciate the tip. This is the direction I'm pursuing.

Chris


"Dan Brussee" <dbrussee@NOSPAMnc.rr.com> wrote in message
news:g6o8pvg841jg6mgtvlq5cfo3cla4fvcg77@4ax.com...

> On Mon, 20 Oct 2003 10:02:36 -0400, "Cobb" <ccoyusa@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 :)
>
>