How to report same record id's in row

Abraham Olatubosun

Dear Code Masters,

I believe this mail meet you well and in good condition.

Please i have this challange and i will appreciate your solution to resolve it, i have a database called tbl_Leavesheet that contain the follo record as shown below:

i was asked to write a report that will keep the same record in one row, their startedate and stopdate in different colun while their nodays will accumulate and display in another column of the same row, it should look like the one below:

all sample code is strongly appreciated.

thank you all

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vivek Kumar9y ago
Hi Abraham,
I have written article in Export Data To Excel File Using EPPlus so you can take help from there.

http://www.c-sharpcorner.com/article/export-data-to-excel-file-in-asp-net-using-epplus/

And as per your problem, you can go for loop for specific column. If you are not clear then please elaborate more your question.
Abraham Olatubosun9y ago
Many thanks Vivek,

I actually use EPPLUS to write my report to excel becuae it allow me to show my client the result from the server, however i am hoping someone have solve this type of problem before so that i can learn from their sample, i have writting and errase many triers and my client what this project close out on the 10th of June 2017.

I am hoping on you guys, thanks for all your support.
Vivek Kumar9y ago
you can use foreach loop and based on your business rule you can fill/blank space the data into the excel sheet.
Have a look into the below links for creating the excel sheet in C#.

http://www.c-sharpcorner.com/article/export-data-to-excel-file-in-asp-net-using-epplus/

http://www.c-sharpcorner.com/UploadFile/bd6c67/how-to-create-excel-file-using-C-Sharp/

http://csharp.net-informations.com/excel/csharp-create-excel.htm

https://www.codeproject.com/Articles/20228/Using-C-to-Create-an-Excel-Document

http://www.leniel.net/2009/07/creating-excel-spreadsheets-xls-xlsx-c.html