Where I work there are some procedures in the database (SQL Server 2008) that take hours to execute and return large amounts of information that are always copied to a worksheet and sent to the end user.
There are even some desktop applications that can run them but this is not very practical;
Processed example:
Isthereanywaytoautomatethesereportsthroughawebapplication?
Itwouldbeperfectiftherewassomewayfortheusertotriggertheprocedureandleaveitrunningthroughthewebsothatatanothertimehecouldre-enterthewebsiteandgetthereport.
IknowalittleofASP.NET,butIhavenoideaifyoucandothis...
Nowreportsareleftrunningontheuser'smachinethroughadesktopapplicationthatgeneratesanExcelfileorthroughtheSQLServerManagementStudioitselfwherethesupporterconnectstothedatabase...
p>Leavetheprocedurerunningontheserver
And when it finishes executing, it copies the result to an Excel spreadsheet and sends it to the user who requested it.
But many of these procedures are time-consuming and so I'd like you to have a way to let the user do this for a web application.
Any ideas?