Hello,
I have a timesheet table I want to report on. Each record has a start date-time and end date-time and activity.
I am trying to create a timesheet setup and dynamically display a colored box for every half hour during the period worked (onle line per 24 hour day). So for monday and activity "Support" there may be two hours worked in the morning, 2 befreo lunch, 3 hours in the afternoon, and 1.5 hours in the evening. I want to display all these intervals on one line in crystal.
I have grouped the data based on activity and for each day there may be several start and end times. In my group it is only picking up the first start and end times.
I can get the first value, next, and max but what if there is more than 3 in out logs during the day. Should I be using some sort of array.
Any help is appreciated.
Database: MSSQL, Oracle, ASA
Crystal: XI
APB
I have a timesheet table I want to report on. Each record has a start date-time and end date-time and activity.
I am trying to create a timesheet setup and dynamically display a colored box for every half hour during the period worked (onle line per 24 hour day). So for monday and activity "Support" there may be two hours worked in the morning, 2 befreo lunch, 3 hours in the afternoon, and 1.5 hours in the evening. I want to display all these intervals on one line in crystal.
I have grouped the data based on activity and for each day there may be several start and end times. In my group it is only picking up the first start and end times.
I can get the first value, next, and max but what if there is more than 3 in out logs during the day. Should I be using some sort of array.
Any help is appreciated.
Database: MSSQL, Oracle, ASA
Crystal: XI
APB