Crystal Reports Days and work hours display

[OutInLeftField]

I have to create a crystal report in Visual Studio .net that looks like the following:

Day On Off On Off...
Monday 8:30 12:00 1:00 5:00
Tuesday 8:30 12:30 1:30 5:00

etc.

any ideas how to do this? I know you can make a crystal report and pass the data to it and display. but how do I display the data in the format as seen above?

thank you

 

[lbass]

You would have to show us a sample of how the data currently displays if the fields are placed in the detail section of the report, using the field names in headers so we know what fields you are referencing.

-LB

 

[OutInLeftField]

empid workid datetime hours workcode desc

Mshehan 1 2007-05-29 08:30:00.000 0.0 On
Mshehan 2 2007-05-29 12:30:00.000 4.0 Off
Mshehan 1 2007-05-29 13:30:00.000 0.0 On
Mshehan 2 2007-05-29 17:00:00.000 3.5 Off
Mshehan 1 2007-05-29 17:30:00.000 0.0 On
Mshehan 2 2007-05-29 20:15:00.000 2.75 Off

first column is user id.
second col is the work id. when someone puts in their time, the user enters what time they started ie 8:30 am. Then the user enters 12:30 for lunch (off). Next the user enters 1:30 (13:30 as On) and so on.

third column is the hours between On and Off. See 8:30 - 12:30 is 4 hours.

fourth column is the description for the work id designated as On and Off.

thank you