Currently, executing a [url removed, login to view] page by passing in the following parameters will result in a populated header of the asp page, datagrid, and an export/print command.
Once the page is generated, choosing "Export" generates a PDF of the report. What i need to be able to do is to perform this routine via a scheduled task in a ReportSchedules table. From there, the PDF needs to be e-mailed to a distribution list set in my ASP front end also stored in MSSQL Server db. I will also need to log each time the report runs as scheduled (or returns an error), etc. into a ReportSchedulesLog table.
I am needing 'assistance' in building the scheduling routine to pick up data from the table, run the report from ASP, generate the PDF, send the PDF, and log the result from the schedule. I can offer other technical details on this job as needed. The reports table is populated, and I can populate the notification table as needed, and modify or populate the reportschedules table based on need of developer.
I have today to complete this project. Whichever freelancer can complete this task by tomorrow morning, please let me know. I will pay reasonable price for this.
The thought on accomplishing this task is to maybe setup a schedule to load ASP page which runs procedure with parameters from user, saves result to PDF, stores PDF in database, emails to assigned distribution list, and reset schedule to run again. This can be done through SSRS, scheduled task, or any other mechanism. Urgency is important here.
The following task need to be done:
1.) Download source from SVN repository and load to Visual Studio
2.) Using [url removed, login to view], develop page that contains necessary things to schedule (report name from Reports table, parameters, assign existing distribution list and loop through emails in distribution - and/or - add in custom emails
3.) Add a custom "scheduled report name" to the scheduled report (e.g. Report Name - Weekly, etc.)
4.) Create automated way that PDF is created from result-set (the page that contains the final result "[url removed, login to view]" already exists but would need data passed to it, etc.)
5.) Setup email routine to email with proper subject, attachment, emails, etc.
6.) Logging table for all report runs and status of run (this table already exists in my MSSQL2008 database)