June 9, 2009 at 12:54 am
Hi SQL Gurus,
I have created a SQLview from a query which would reveal the following results from the server "my-server" with UN = user and password = pwd :
Ticket Open_Date Close_Date Group
12345 12-05-2009 00:12:00 12-05-2009 00:15:00 SQL
45678 12-05-2009 00:12:00 12-05-2009 00:15:00 TSQL
76890 13-05-2009 00:12:00 12-05-2009 00:15:00 MYSQL
67900 13-05-2009 00:12:00 12-05-2009 00:15:00 SQL
56789 14-05-2009 00:12:00 12-05-2009 00:15:00 TSQL
96789 14-05-2009 00:12:00 12-05-2009 00:15:00 SQL
How can I create a webpage in ASP / JSP Page so that I can launch it in IIS and it should have four fields as given below :
Open_Date(Initial) Open Date (End) Group GO
When I enter the Open_Date(Initial) and Open_date (End), select a group from Drop down (e.g. SQL). It should give me all the ticket information (All rows from the table) where Open_date is in between the Dates specified. When I click on GO, I should be able to save it as an excel sheet.
Any help would be appreciated.
June 10, 2009 at 1:44 am
Reporting Services can do this for you. It provides a web based report which can be exported.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply