Sql query graphing through Web page

[hayesrj4]

Hows it goin.
I'm a newbie so forgive the probably silly question. Every week i prepare a report by querying with sql, then throwing the results into excel to obtain graphs for the report(the report is small just graphs tbh). I however have no real knowledge of sql (all i do is change dates).
All of a sudden i have been given a small project on how to automate this process so anyone can access this info from a simple gui/web page which will show the graphs for them. Basically what i need to know is how to set this thing up ie creating the web page which queries the database through sql and displays the results in a bar chart eliminating the manual steps. I don't know where to start so any advice would be well apreciated. Again i have to apologise for being so uninformed.

Thanks

 

[gmmastros]

There are really 2 things going on here.

1. You're changing the dates in the query to run.
2. You are displaying the results in a graphical format.

Currently, you are using 2 different technologies to do that. You're using SQL to get the data and excel to display the graph.

Most people don't realize this, but you can use excel to get data from a sql server database. I think you use VBA within excel to do that. So, I suggest you create an excel document that can query that database based on a date that is typed in to a cell.

If you post your question in the VBA Visual Basic for Applications (Microsoft) Forum forum707, someone there should be able to help you a little better.


-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[hayesrj4]

Thanks man. Much appreciated

 

[jbenson001]

What web development software do you plan on using?

 

[hayesrj4]

Not too sure yet. Any suggestions?

 

[hayesrj4]

Was just talkin to someone who did somethin similar a few months ago and he was saying that he used Visual Web Develepor and put in the sql code but that the code needs to be played around with a bit before working (a lot of syntax issues i think)