Hi All,

Scenario: .asp page gives front-end for from date and to date selection, the page sends the parameter to procedure, the out put is shown on HTML table.

Problem: As reports are too complex, it takes so long for execution and causes session expire etc.

Requirement: The user should be able to select date from front end and after submiting he should be able to come out of application, once report is generated that should be sent to user via email as attachmnt.

What can be the best solution for above problem on Sql server 2000 and/or 2005.

Thank you.