Hi all,

I have table in my DB with following columns

ID,emp_id,project_id,empfname,emplname,projname,workdate,worktype,timespent.

Following is the sample data in my table

as i mentioned the columns, data is in the same order

I am allowing the user to select from date...based on this i set the end date ie.,frmdate + 6days... no problem

 now i need to pull the report for a week and display to the user in the following format

WorkType    |  5/12/2008  |  5/13/2008  |  5/14/2008  | 5/15/2008  | 5/16/2008  |  5/17/2008  |  5/18/2008  |  Hours

Coding        |  totalhrs on 5/12/2008 day for coding   |  totalhrs on 5/13/2008 day for coding  |...................................................................................| total hours for the week

I need to display in the above format...can any one help me out ..plzzzzzzzz.... 

Do you want the display in a web application or on a console?

Also, this sounds like a home work project.  Is it?

Hi,

This is an web application...it's our internal application... 

do u have any solution...???

I'm not going to code the whole thing and hand it to you.  That's your job.

If you have specific problems, post them.

If you don't know where to start, there are a host of asp.net books and online articles and tutorials that explain how to do this.  There are starter kits on this website so you can see working pages in action along with the code.  Check that stuff out, then come back with specific problems that you are having trouble with.

:-) well said

You can accomplish this in several ways. Try this: 

Create a select statement for sum of timespent group by worktype and workdate for the given date range.

Now use pivoting technique (pivot the workdate column) or looping to dump the data into a dataset/datatable

Now attach this to GridView dynamically.

Regards

Vasu