I have a project, it's an asp.net application using SQL 2005 as back end (will soon be upgraded to 2008 R2)
I wonder what would be the best approach to realize this feature:
My user can receive periodically generated report and the period s/he receives the report will be adjustable by himself/herself.
My initial thinking is to create a Windows application in .NET and using SQL job to call it. The problem is how do I make it scheduled and the schedule could be updated by user from a front-end page (off course the page can let user to update some field in database)
Is my idea feasible? If yes, how do I use the front-end page to update the schedule parameter to call the external Windows Application?
Maybe Reporting Service is better? I never use it before, I used Crystal Report which is such a garb***, headache everywhere. I don't want to use it unless no better solution.
If there is better approach, please enlighten me.
Thank you very much.