Closed

C# script to produce csv report

I need a C# script written that will generate a CSV report for me in the same format that i have attached in the spreadsheet.

The details are as follows:

I have a PROJECT table which has a one to many link to a TASK table. They are joined via projectid key.

There is also a USER table which is linked via projectmanagerid to the PROJECT table.

The selection criteria for the report is:

SELECT PROJECTID FROM TASK WHERE [url removed, login to view] IS GREATER THAN OR EQUAL TO CURRENT DATE AND LESS THAN OR EQUAL TO CURRENTDATE + 60 DAYS.

So it will select any number of projects that contain tasks in those days. Then for each project i want it to output the project info in each column, then each row will output each day up to 60 days and any tasks for that project on the respective day.

The attached example might make it easier to understand.

I will provide an actual MSSQL database for the winner.

Thanks

Skills: C# Programming, Software Architecture

See more: csv report, spreadsheet script, script programming, report programming, programming tasks in c++, programming projects c++, key selection criteria, key selection, key programming software, key criteria, a written report, csv spreadsheet, report example, key programming, C Sharp Programming, c c++ c# c# c sharp, selection criteria, produce, IT report, csv, c++ 11, c# MSSQL, c# architecture, c sharp, output script

About the Employer:
( 2 reviews ) west croydon, Australia

Project ID: #1243058

36 freelancers are bidding on average $88 for this job

srinichal

I look forward to deliver the script in C#

$80 USD in 3 days
(71 Reviews)
6.9
AlosDeveloper

Hello, can be done on c#

$40 USD in 1 day
(21 Reviews)
6.3
qtorixsystems

ready to start please check pm.

$100 USD in 1 day
(21 Reviews)
6.0
ehsankayani

HI, Kindly see my work profile all the jobs i have done so far involve entry into excel from websites,sql or tables etc... Highly skilled for this work , can provide tons of sample also for more work detail kindly s More

$80 USD in 1 day
(23 Reviews)
5.8
sureshdevi

I can create c# script to retrieve the tasks of each selected projects from MSSSQL database and finally generate CSV file by date. Thanks, Suresh

$62 USD in 2 days
(47 Reviews)
5.3
BitsLogic

Dear Sir, We are interested in working with you. Over the years we have worked on many projects, both large and small. They have varied in complexity from simple reusable modules to enterprise-wide web-enabled applica More

$179 USD in 5 days
(2 Reviews)
5.0
Celoks

Please Check Pm...

$50 USD in 0 days
(7 Reviews)
4.9
tuyenvt

Dear Sir ,Please see My profile.I can do [url removed, login to view]

$30 USD in 1 day
(11 Reviews)
4.7
sikandermandal

Please See PMB.

$50 USD in 2 days
(8 Reviews)
4.6
NDCorps

Extensive experience in C#.Net, WPF and SQL server, plz check PM.

$130 USD in 3 days
(9 Reviews)
4.6
AlexMDumitru

Please check PMB.

$50 USD in 1 day
(6 Reviews)
4.5
CreativePowerCo

Hi buyer, This is really easy for me. Please hire me. I had exerience on working with excel & C#. See my profile for details.

$30 USD in 1 day
(3 Reviews)
3.6
pramodv

please check pmb.

$35 USD in 5 days
(14 Reviews)
3.2
NightCoders

Hi I Can Easily do this [url removed, login to view] go through My resume

$150 USD in 15 days
(1 Review)
3.0
smartlabsolution

Hi, We can do this for you. Please check your pm for details. Thanks!!

$100 USD in 0 days
(4 Reviews)
2.7
ishan1988

hi bunstar i have done same functionality in my earlier projects i already have its code,i would love to use my prior knowledge along with your requirements and will deliver you the solution within 3-4 hours

$30 USD in 1 day
(5 Reviews)
2.2
mdaxini

Hello, I would like to do this job. please contact me asap. Thanks, md

$300 USD in 10 days
(1 Review)
1.2
iosifrn

Hello, We have over 15 years of programming experience in MS Access, SQL Server, ORACLE, C#, Visual Basic, VBA, ASP.NET, Web Development and others. We can help you with this project and any other projects you may hav More

$100 USD in 5 days
(1 Review)
1.0
XPTeamuk

Hello Firstly, just to comment that the requirement specification given is very clear and concise so thanks for that. The requirement is simple and straightforward and should not pose any major hurdle in comple More

$150 USD in 5 days
(0 Reviews)
0.0
sumedharajkumar

We have a strong team of C# expert. we can complete your work within 1 day.

$50 USD in 1 day
(0 Reviews)
0.0