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.
36 freelancers are bidding on average $88 for this job
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