Find Jobs
Hire Freelancers

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

$30-250 USD

In Progress
Posted over 11 years ago

$30-250 USD

Paid on delivery
Currently, executing a [login to view URL] 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 [login to view URL], 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 "[login to view URL]" 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)
Project ID: 2435552

About the project

7 proposals
Remote project
Active 12 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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, BI reporting and five years of application development experience. I would highly appreciate if you assign this job to me and also I'm Microsoft Certified Technology Specialist (MCTS) for Microsoft SQL Server 2008 for Business Intelligence Development and Maintenance & Microsoft Office SharePoint Server Application Development. Please check the attached SSRS sample and reply me for further details Best Regards, Jinesh
$150 USD in 5 days
4.9 (27 reviews)
4.6
4.6
7 freelancers are bidding on average $291 USD for this job
User Avatar
Hello, i am ready to start. Let's discuss your project more deeply in message board
$700 USD in 10 days
5.0 (58 reviews)
6.8
6.8
User Avatar
Please see PMB.
$250 USD in 1 day
5.0 (23 reviews)
5.5
5.5
User Avatar
i have those specific skills to complete project to your satisfaction
$200 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have experience in SSRS and also creating scheduling jobs for email. Thanks, Hancy
$200 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
please check my pm
$300 USD in 20 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Bellevue, United States
5.0
16
Payment method verified
Member since Apr 3, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.