How would I build a Graphical Timeline

Discussion in 'ASP General' started by Cobb, Oct 20, 2003.

  1. Cobb

    Cobb Guest

    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, Oct 20, 2003
    #1
    1. Advertising

  2. Cobb

    Dan Brussee Guest

    On Mon, 20 Oct 2003 10:02:36 -0400, "Cobb" <> 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 :)
    Dan Brussee, Oct 20, 2003
    #2
    1. Advertising

  3. Cobb

    Cobb Guest

    Thanks a bunch!

    Chris


    "TJS" <> wrote in message
    news:...
    > try this:
    >
    > http://www.aspkey.net/aspkey/_store/asp/store.asp#projectdisplay
    >
    >
    > "Cobb" <> wrote in message
    > news:%...
    > > 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, Oct 21, 2003
    #3
  4. Cobb

    Cobb Guest

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

    Chris


    "Dan Brussee" <> wrote in message
    news:...
    > On Mon, 20 Oct 2003 10:02:36 -0400, "Cobb" <> 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, Oct 21, 2003
    #4
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. dw

    Timeline for ASP.NET 2.0

    dw, Jan 3, 2005, in forum: ASP .Net
    Replies:
    4
    Views:
    1,196
  2. davidshook
    Replies:
    7
    Views:
    1,897
  3. Andy Salnikov

    Timeline plots with Python

    Andy Salnikov, Apr 2, 2004, in forum: Python
    Replies:
    1
    Views:
    891
    Roy Smith
    Apr 2, 2004
  4. Sebastian Bassi

    Timeline for Python?

    Sebastian Bassi, Aug 31, 2006, in forum: Python
    Replies:
    7
    Views:
    403
  5. wesley chun

    Re: Timeline for Python?

    wesley chun, Sep 23, 2006, in forum: Python
    Replies:
    6
    Views:
    362
    Blair P. Houghton
    Sep 26, 2006
Loading...

Share This Page