(C#) Build scheduling and email disribution page that output from MSSQL08 procs that populate an ASPX page.

IN PROGRESS
Bids
7
Avg Bid (USD)
$291
Project Budget (USD)
$30 - $250

Project Description:
Currently, executing a ReportContainer.aspx page by passing in the following parameters will result in a populated header of the asp page, datagrid, and an export/print command.
1.) storedProcName=
2.) startDate=
3.) endDate=
4.) groupID=
5.) locationID=

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 Site.Master, 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 "PrintReport.aspx" 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)

Skills required:
.NET, AJAX, ASP, C# Programming, SQL
Additional Files: Report+Scheduling+Specs.docx
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire AlosDeveloper
$ 700
in 10 days
$ 240
in 3 days
$ 250
in 1 days
$ 150
in 5 days
$ 300
in 20 days
$ 200
in 5 days
$ 200
in 7 days