SitePoint Sponsor

User Tag List

Results 1 to 15 of 15

Hybrid View

  1. #1
    SitePoint Addict
    Join Date
    Jun 2001
    Location
    Malaysia
    Posts
    352
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    SQL Server 2000: Displaying rec. as graphics?

    Hey guys,

    Am using SQL Server 2k.. and I was wondering if there's a way to somehow display SQL SELECT statements not in plain ol' text form... but rather as pie charts, graph bars and other sort of graphical displays?

    Is there a way to do this in SQL Server 2K, or does anyone know of any 3rd party software to do this?

    PS: Am using ASP.....

  2. #2
    I'm a college yuppie now! sbdi's Avatar
    Join Date
    Jul 2000
    Location
    Dublin , Ireland
    Posts
    1,271
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I heard that in Coldfusion 5 its possible you could try that maybe? Also I heard that PHP can make images from database results so if they dont have cfm they should have php.

    You could also try and replace the number with a certain amount of graphics as well.
    Back Again

  3. #3
    SitePoint Wizard silver trophy Jeremy W.'s Avatar
    Join Date
    Jun 2001
    Location
    Toronto, Canada
    Posts
    9,123
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    ASP can make images from databases as well. There are COM components around which are meant for creating graphs and such from a SELECT.
    SVP Marketing, SoCast SRM
    Personal blog: Strategerize
    Twitter: @jeremywright

  4. #4
    SitePoint Wizard big_al's Avatar
    Join Date
    May 2000
    Location
    Victoria, Australia
    Posts
    1,661
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    If you have Office installed on your system you can use the Office Web Component (OWC) to draw graphs
    .NET Code Monkey

  5. #5
    SitePoint Addict
    Join Date
    Jun 2001
    Location
    Malaysia
    Posts
    352
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hey cool... ASP can actually "parse" SELECTs to graph forms?

    Any good website links to doing this? Preferably one with a short tutorial(s).....

    Also does this mean that the conversion from SQL syntax to graph form takes place within ASP code... or thru SQL Server 2k?

    Thanks guys!

  6. #6
    SitePoint Wizard silver trophy Jeremy W.'s Avatar
    Join Date
    Jun 2001
    Location
    Toronto, Canada
    Posts
    9,123
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    big_al is actually saying you would do the select through a COM object which would build the output for you.

    If you're not sure what any of the above means, let us know
    SVP Marketing, SoCast SRM
    Personal blog: Strategerize
    Twitter: @jeremywright

  7. #7
    ALT.NET - because we need it silver trophybronze trophy dhtmlgod's Avatar
    Join Date
    Jul 2001
    Location
    Scotland
    Posts
    4,836
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You can actually store an image in a db, yeah? I swear you can... I'm going to write a script...

  8. #8
    SitePoint Addict
    Join Date
    Jun 2001
    Location
    Malaysia
    Posts
    352
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by Jeremy W.
    big_al is actually saying you would do the select through a COM object which would build the output for you.

    If you're not sure what any of the above means, let us know
    I'm not sure! Just how do you go about doing this?

    Thanks again, guys!

  9. #9
    SitePoint Addict
    Join Date
    Jun 2001
    Location
    Malaysia
    Posts
    352
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    hi guys...

    Anyone have any idea on my previous post?

    Thanks a bunch!

  10. #10
    SitePoint Wizard
    Join Date
    Jan 2001
    Location
    Milton Keynes, UK
    Posts
    1,011
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Try this MS KB article on using the MS OWC charting component.

    In the article they create some random data (in the arrays Categories and Vals). They then pass these arrays to the charting component. MS doesn't seem to have much online docs. for the component.

    As you're getting your data from a db you'll just need to extract the data using regular sql and then pass it to the charting object. You may be able to pass the recordset to the charting object or you may have to do some manipulation of it first.

    Theres a load of commercial charting components if you've got some cash to spend.
    www.componentsource.com

    The Dundas Pie Chart Server (23 on the list above) is free and good, if pie charts are all you want.

  11. #11
    SitePoint Addict
    Join Date
    Jun 2001
    Location
    Malaysia
    Posts
    352
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    thanks Shane,

    Will post again once I view the sites you reccomended......

  12. #12
    SitePoint Addict
    Join Date
    Jun 2001
    Location
    Malaysia
    Posts
    352
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by shane
    Try this MS KB article on using the MS OWC charting component.

    In the article they create some random data (in the arrays Categories and Vals). They then pass these arrays to the charting component. MS doesn't seem to have much online docs. for the component.

    As you're getting your data from a db you'll just need to extract the data using regular sql and then pass it to the charting object. You may be able to pass the recordset to the charting object or you may have to do some manipulation of it first.

    Theres a load of commercial charting components if you've got some cash to spend.
    www.componentsource.com

    The Dundas Pie Chart Server (23 on the list above) is free and good, if pie charts are all you want.

    I'm still unsure of how to go about implementing this in ASP....

    I've reviewed all the MS KB articles, which mentions the use of MS Visual Interdev. Any other software that'll let me accomplish this, besides VI?

    Also, it would be great if someone had a great step by step tutorial on accomplishing this.. I just started out on ASP from PHP.. so this is kinda hard getting used to..

  13. #13
    SitePoint Addict
    Join Date
    Jun 2001
    Location
    Malaysia
    Posts
    352
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    desperately need assistance.. anyone?

  14. #14
    SitePoint Evangelist Umair.ms's Avatar
    Join Date
    Sep 2000
    Location
    Lahore, Pakistan
    Posts
    567
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Why dont you give it a try in PHP then? In ASP it is possible through ASP COMponents only.

    Or you can tryout another thing. Flash!
    TinyPlanet.org
    Discuss and Debate World Events, Politics and Religion.
    Interact and Share your Views with People around the Globe.

  15. #15
    SitePoint Wizard big_al's Avatar
    Join Date
    May 2000
    Location
    Victoria, Australia
    Posts
    1,661
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi,

    You could use a quick and dirty way of drawing your graphs by doing some maths to work out percentages, qty's, what ever you wanted, than display that by putting an image in the background of a table row and then inserting the result as the width of the field (like the SPF Poll's)

    Otherwise.
    Check out www.4guysfromrolla.com they have a great tutorial on OWC
    .NET Code Monkey


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •