Generic Web Question - SQL Access for reporting
Posted on 2001-07-10
I am a VB 6.0 Database programmer dog who is trying to learn some new tricks!
I have a project that I am going to be working on which I could use some guidance on. I have a couple of tables in a MS SQL database which I need to generate some reports on. These reports will vary based on the users input in requesting the report (e.g. date ranges).
Thinking that it is time to work with some new tools and tricks (at least to me), I would like to pursue this project via the WEB; setting up a page that the user could fill in for their report parameters, submitting a resulting query to the server and then formatting a page with the resultant data.
I am somewhat familiar with HTML from the standpoint that I have written a number of VB apps which in turn generate static HTML pages for some reports. I am looking for something more elegant here.
I would like someone to outline a method to do the above task; e.g. which tools to use (CGI, PERL, ASP), server side or client side processing, that sort of thing.
Will appreciate all responses and will be generous with points!