In Progress

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

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.

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 [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)

Skills: .NET, AJAX, ASP, C# Programming, SQL

See more: visual studio pdf, visual studio job, technical report in pdf, ssrs job, repository.db, project status freelancer, procedure for freelancer, price freelancer c#, net freelancer price, net c# freelancer, need developer c# net freelancer, mssql freelancer, master freelancer, loop net, log into freelancer, i need asp email, front end list freelancer, freelancer site build, freelancer server set up, freelancer server setup, freelancer schedule, freelancer routine, freelancer reset, freelancer net what do i need, freelancer log up

About the Employer:
( 16 reviews ) Bellevue, United States

Project ID: #2435552

Awarded to:

marasinghe82

Dear Sir, Please assign this task for me I can assure 100% completion. I'm very much familiar with MS SQL Server ( SSIS SSAS SSRS) and also during last five years I involved many project in ETL, data warehousing, More

$150 USD in 5 days
(27 Reviews)
4.6

7 freelancers are bidding on average $291 for this job

AlosDeveloper

Hello, i am ready to start. Let's discuss your project more deeply in message board

$700 USD in 10 days
(58 Reviews)
6.8
aptecpymefree

We can work in your proyect. I am a leader of the team. I have 14 Years of experience in Software development Windows and Web. Expert in Sql Server and .NET. Microsoft Certified as MCP, MCTS, MCPD, MCT. Please contact More

$240 USD in 3 days
(20 Reviews)
5.6
sikandermandal

Please see PMB.

$250 USD in 1 day
(23 Reviews)
5.5
stevchen99

i have those specific skills to complete project to your satisfaction

$200 USD in 7 days
(0 Reviews)
0.0
ntechinfotech

Hi, I have experience in SSRS and also creating scheduling jobs for email. Thanks, Hancy

$200 USD in 5 days
(0 Reviews)
0.0
shahdat45ict1

please check my pm

$300 USD in 20 days
(0 Reviews)
0.0